Senior Database Administrator II

Anthology Inc

7 - 12 years

9 - 14 Lacs

chennai bengaluru

Posted:3 weeks ago| Platform:

Apply

Skills Required

linux networking mysql database administration senior database administrator windows oracle microsoft sql python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Deploying new database systems and ancillary services including design, layout, configuration, and tuning
Monitoring existing database systems for availability, performance, and scalability
Maintaining database security ensuring appropriate levels of access are maintained, backups are being taken according to established guidelines, and that backups are periodically tested to ensure recoverability
Troubleshooting issues impacting the availability, stability, and performance of our databases at scale. This includes not only the database engine but the operating system it is running on and the SQL it is running as well
Understanding the query profiling infrastructure, execution statistics, and execution plans
Analyzing, understanding, and editing database objects, code, and scripts
Documenting databases, database processes and procedures, as well as changes and incidents
Collaborating with other database administrators as well as internal teams and external clients on issues, projects, initiatives, etc.
Developing and maintaining an in-depth understanding of the application infrastructure, functionality, and overall systems design as it relates to the databases
This role requires the willingness to work 5 days per week including shifts (morning/afternoon/night), weekends and off-shift/on-call as needed

The Candidate:

Required skills/qualifications:

At least 7 years of experience administering all aspects of SQL Server and PostgreSQL databases including installation, configuration, deployment, and general administration of the database engine, creating and maintaining databases and database objects (logical and physical), performance tuning, optimization, networking, and security
Experience with virtualization including Microsoft Azure Cloud and Amazon Web Services
Basic knowledge of the Windows operating system and how it interacts with the database
Database scripting skills. Ability to read, analyze and write Transact-SQL
System scripting skills. Ability to read, analyze and write batch files and PowerShell scripts
Deep expertise in troubleshooting slow-running queries, optimizing indexes, analyzing execution plans, and improving database performance at scale.
Provide Backup and Recovery
Strong understanding of database security models, encryption, and auditing practices to meet organizational and compliance standards.
Experience with SQL Server replication types and the services that support them (Change Tracking, Change Data Capture, etc.)
Experience designing, configuring, and testing database standard and high availability models
Experience with reporting services including SQL Server Reporting Service (SSRS), Analysis Service, and PowerBI
Ability to participate in code walkthroughs and review database migrations
Ability to lead DB modernization projects, mentor junior DBAs, engage with development teams for schema reviews, and work closely with cloud/infrastructure teams to ensure performance and scalability.
Ability to review planned changes to database objects with an eye towards maintaining data integrity (implementation of primary keys, necessary foreign-key constraints, etc.), performance (indexes, index types, partitioning, etc.), and storage utilization and growth
Fluency in written and spoken English

More Jobs at Anthology Inc

Associate Software Engineer II

Chennai, Tamil Nadu, India

1.0 - 2.0 yrs

Salary: Not disclosed

Tier 3 Support Engineer

Chennai, Tamil Nadu, India

2.0 - 5.0 yrs

Salary: Not disclosed

Software Engineer II

Chennai, Tamil Nadu, India

3.0 - 5.0 yrs

Salary: Not disclosed

Customer Success Manager

Bengaluru, Karnataka, India

5.0 - 8.0 yrs

Salary: Not disclosed

Software Engineer I

Bengaluru, Karnataka, India

3.0 - 5.0 yrs

Salary: Not disclosed

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.