Subject Matter Expert

Future Focus Infotech Pvt. Ltd.
  • Chennai
  • 3-8 lakh
  • 5-10 years
  • Views
  • 21 May 2018

  • Software Design & Development

  • Consumer Durables/ Semi Durables
Job Description

Required Skills - Hands on experience in SQL DBA Should be comfortable to work in SQL,PL SQL, T-SQL Work with database users and resolve data-specific problems. 1. Act as Subject Matter Expert on database structure and design.  2. Assist IT and Business teams on new system implementations and architecture.  3. Recommend changes to Optimize poorly performing programs, queries and Stored Procedures by working with the responsible application developments teams. Monitor the performance of individual SP's and Queries, based on the performance results, suggest additional changes to the query as well as recommendations on indexes or maintenance such as stats and reorganizations. 4. Assist in the assessment of application performance and load on the application database. Provide suggestions to concerned developers where database access mechanisms can be optimized. 5. Recommend changes to the current design/architecture of Database solutions. Implement new architectures which can give a database solution wide performance gain and assure solutions scalability and modularity. Support and collaborate with Enterprise architecture team to enforce Industry best integration practices within the Application teams. 6. Design and implementation of Database Architecture. Data Normalization, de-normalization. Creation of tables, views, common functions and Stored procedures. Proper use of datatypes and structures. Implementation of Keys and constraints. 7. Define the minimum-security credentials each role/user requires and enforce the defined security policy. 8. Review stored procedures/functions. Evaluate compliance with the defined standards and best practices through code reviews. 9. Define, create and maintain standards, policies and best practice by defining and enforcing organization wide and individual  Decent Communication Should be able to join immediately or within 15 days

Competencies/Skill sets for this job

Sql Dba Plsql

Job Posted By

Executive Delivery

About Organisation

Future Focus Infotech Pvt. Ltd.