Senior SQL DBA

This position is responsible for providing production database operations ensuring performance and scalability high availability and disaster recovery compliance and security of database servers. This role also provides technical leadership within DBA team.

Additional responsibilities include developing best practices and repeatable procedures for deploying databases day-to-day operational activities including break/fix space management backup and restore performance monitoring and tuning.  The individual filling this role makes recommendations for physical database design architecture and testing of database technologies.  Identifies data sources constructs decomposition diagrams provides data flow diagrams and documents the process.  Writes code for database access modifications and constructions including stored procedures.  Maintains version control for promoting changes into production environments.  Has good understanding of storage systems and various application integration architectures.  Supports production environments 24x7.

Key Responsibilities:

• Manages databases through multiple product lifecycle environments from development to mission critical production systems.
• Applies data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyzes solves and corrects issues in real time providing problem resolution end-to-end.
• Refines and automates regular processes tracks issues and documents changes.
• Assists developers with complex query tuning and schema refinement.
• Provides 24x7 support for critical production systems. Participates in an On-Call rotation as needed
• Performs scheduled maintenance and support release deployment activities after hours.
• Shares domain and technical expertise providing technical mentorship and cross training to other peers and team members.
• Installs configures patches and upgrades database servers. Manages on-prem and cloud based (Azure-preferred) database servers and services in PaaS and IaaS cloud solutions.
• Provides high availability solutions for multiple database configurations.
• Uses extensive experience in disaster recovery solutions and best practices to create maintain and verify backups using native and 3rd party solutions. Discusses RPO and RTO strategies with business leaders.
• Performs advanced performance monitoring and troubleshooting. Creates execution plans uses database optimizers and has experience using database-specific monitoring technologies.
• Applies a cybersecurity mindset and best practices to secure Database servers. Interacts/guides audit and compliance teams. Uses data security/encryption mechanisms (e.g. TDE data masking/redacting/subsetting). Hardens database servers based upon security hardening requirements. Assists with security audits from internal and external providers.
• Identifies and resolves capacity issues. Regularly monitors/reviews performance metrics to identify trends and future risks in the environment before they happen and works with leadership to get the work prioritized. Partners with the Enterprise Systems Services team on physical design and implementation of database infrastructure
• Identifies troubleshoots and resolves performance issues including expensive SQL queries blocking/deadlocking excessive waits etc

Qualifications:

• 6 years SQL Database Server Administration experience
• Monitoring software systems to detect potential database problems. Investigating troubleshooting and evaluation of Production database problems.
• Recommending and implementing approved solutions and documents the problem / resolution.
• Writing testing and implementing operating system scripts and procedures to automate various SQL DBA functions and processes.
• Coordinating development testing and implementation of database systems to meet database capacity standards and sizing objectives.
•  Assisting in managing and maintaining database backups.
•          o Performing database and application upgrades.
•          o Installing/maintaining/upgrading multiple instances of Oracle databases
•          o Developing Architecture Diagrams and Instance Strategy Diagrams
•          o Cloning the SQL database for dev and test environments
•          o User administration identifying User issues and resolving the issues.
•          o Create test and implement operating system documentation and procedures.
•          o Plans and monitors assigned projects and communicates project progress.
•          o Writes maintains and files necessary system documentation and procedures
• 24x7 coverage for Production systems.
• Maintaining proactive and auto-corrective monitoring practices.
• Disaster recovery processes.
• Assessing complex situations setting priorities and implementing action plans with a business-oriented approach. Must be able to manage end user/customer expectations.
• Effective good verbal and written communications skills and the ability to communicate with management IT staff and customers effectively and professionally.

Qualifications :

• Bachelors degree in Computer Science Engineering Mathematics Statistics Data Science Science Business discipline or a related field.
• Hybrid work model: In-office on Monday Wednesday and Friday.
• Working Time: 2:30 PM IST to 11:30 PM IST
• Work Location: Hyderabad Chennai & Pune

Additional Information :

All your information will be kept confidential according to EEO guidelines.

Remote Work :

No

Employment Type :

Full-time