Database Administrator - SQL DBA

Job Title: Database Administrator

Years of Experience: 6+ years

Location: Chennai One (IT Park) - Thoraipakkam

Job Summary/Objective

Oversees all database systems to assure platform stability and customer value. Provides tasking and direction to junior-level DBAs, and proactively analyzes, implements, interprets and troubleshoots the design and architecture of OEConnection’s database infrastructure. Leads and/or participates in related projects and activities; complies with company database standards, policies, procedures, and best practices.

Key Responsibilities & Duties (essential to the job)

1. Designs, implements, deploy/builds and troubleshoots database infrastructure (e.g. maintenance and monitoring components).
2. Assesses database server metrics from monitoring, security and alert events to determine appropriate actions/solutions to remediate problems.
3. Assists developers in analysis of problematic queries and compiled objects (e.g. stored procedures, functions, etc) to recommend tuning changes and sharing optimization techniques.
4. Works to maintain the database fleets performance through continual review of server metrics then tuning of database maintenance and server configuration. In addition this involves recommending optimizations for the application team to their queries and schema design.
5. Continual maintenance of server patch levels and upgrade of server versions across the environment to maintain database product support and general platform stability.
6. DevOps teams when necessary to assess database change and provides recommendations on database change deployment processes. This may include optimizing CI\CD automation processes in conjunction with the DevOps team.
7. Leads and participates in select database architecture and design projects and activities.
8. Identifies, recommends and champions improvements to database infrastructure that increases performance, reduces cost, improves availability, and/or provides more value to customers.
9. Adheres to and complies with company database standards, policies, procedures, and best practices; assists with creating and/or updating, as dictated by business needs.
10. Coaches and guides junior-level database administrators’ technical and business skills.
11. Assesses security risks across the platform in coordination with Security and compliance teams.
12. Determines appropriate levels of access for users based on database security best practice, internal policy and regulatory requirements (e.g. GDPR).
13. Prepare and design system for disaster recovery scenario’s and high-availability requirements.

Education

A bachelor’s degree from an accredited college or university is required, with a focus in information technology/science, or related discipline. In the absence of a degree, equivalent work experience directly related to the key responsibilities of the role will be considered as a substitute for the degree.

Experience, Skills and Key Competencies

• At least 7 years of progressively responsible experience with Microsoft SQL Server database administration in a multiserver multi-database environment, plus thorough understanding of the principles and practices of database administration such as terms, concepts, database software installation/configuration, and operational characteristics of Microsoft SQL.
• Ability to communicate clearly and concisely, both verbally and in writing
• Strong individual contributor and team player attributes when working on and/or leading projects within the department.
• Ability to work cross functionally and communicate company database information to developers, management team members and others as needed.
• Ability to understand and modify T-SQL/ANSI SQL code.
• Ability to understand shell scripts primary Windows DOS and PowerShell and Linux/UNIX Bash (experience not mandatory but willingness to learn is a must).
• Familiarity with server deployable database platforms primarily with SQL Server and additionally with MySQL (experience not mandatory but willingness to learn is a must) as well as Cloud database platforms including primarily Azure PaaS (SQL DB) and AWS RDS (experience not mandatory but willingness to learn is a must).
• Ability to quickly learn and understand OEC business processes, projects, goals, objectives, constraint, and timelines.