Current jobs related to Senior Application DBA - Cochin, Kerala - Williams Lea India Private Limited (KL State)

Role Purpose:

We are currently seeking a highly skilled and experienced Senior Application Database Administrator (DBA) to join our dynamic team. As a Senior DBA, you will play a pivotal role in ensuring the performance, reliability, and scalability of our database systems while leading efforts to optimize and maintain our SQL infrastructure. The ideal candidate will possess a strong background in SQL experience, database administration, optimization, and maintenance, coupled with expertise in AWS cloud services, particularly RDS advanced configuration, PostgreSQL, Aurora, and a keen willingness to learn and lead in Amazon DynamoDB or other AWS cloud-native database technologies.

Key Responsibilities :

Database Design and Architecture :

Lead database design and architecture discussions, collaborating with application developers, architects, and infrastructure teams to ensure optimal database solutions. Design and implement database schemas, tables, indexes, views, stored procedures, and functions to support application requirements efficiently. Evaluate and recommend database technologies, tools, and methodologies enhance performance, scalability, and reliability, leveraging expertise in SQL and cloud-native solutions such as AWS RDS, PostgreSQL, Aurora, and DynamoDB.

Database Administration :

Perform database installations, upgrades, and patching in accordance with best practices and security guidelines. Configure and maintain database instances, including monitoring, tuning, backup, recovery, and disaster recovery strategies. Manage database security, access controls, permissions, and auditing to ensure data integrity and compliance with regulatory requirements.

Performance Tuning and Optimization :

Identify, analyse, and rectify performance bottlenecks in SQL queries through comprehensive SQL profiling, query optimization, and utilization of performance monitoring tools. Develop and implement performance tuning strategies aimed at enhancing database queries, indexes, and configurations to achieve superior response times and optimize resource utilization. Lead capacity planning and scalability assessments to facilitate seamless expansion of applications and data volumes, ensuring robust support for evolving business needs.

High Availability and Disaster Recovery :

Implement and manage high availability solutions, such as database clustering, replication, and failover mechanisms, to minimize downtime and ensure business continuity. Develop and maintain disaster recovery plans and procedures, including regular testing and validation of backup and recovery processes.

Monitoring and Automation :

Establish proactive monitoring and alerting systems to detect and respond to database-related issues in a timely manner. Automate routine database administration tasks, such as backups, maintenance, and provisioning, using scripting languages and automation frameworks.

Documentation and Knowledge Sharing :

Maintain comprehensive documentation of database configurations, processes, and procedures for reference and training purposes. Share expertise and best practices with other team members, providing mentorship and training on database technologies and methodologies.

Essential Skills

Bachelor's degree in computer science, Information Technology, or related field. In-depth knowledge of SQL language, including complex query optimization, indexing, and performance tuning techniques. Proficiency in database design, schema modelling, and database architecture principles. Strong proficiency in AWS cloud services, particularly RDS advanced configuration, and experience with PostgreSQL, Aurora, or similar database technologies. Hands-on experience with database installation, configuration, and administration in both on-premises and cloud environments (e.g., AWS, Azure, GCP). Strong understanding of high availability, disaster recovery, and backup/restore methodologies for database systems. Knowledge of database security best practices and regulatory compliance standards. Excellent analytical and problem-solving skills, with a keen attention to detail, and the ability to troubleshoot complex database issues under pressure. Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams. Passion for staying up-to-date with the latest cloud database technologies and best practices. Relevant certifications such as Microsoft Certified: Azure Database Administrator Associate, Oracle Certified Professional (OCP), or equivalent, are a plus.

Experience

10+ years of experience in database administration, with a focus on SQL-based database systems (e.g., SQL Server, Oracle, MySQL, PostgreSQL). Experience with database monitoring and performance tuning tools (e.g., SQL Profiler, Performance Monitor, AWR, EXPLAIN). Experience with Amazon DynamoDB or willingness to learn and lead in cloud-native database technologies.

Additional Information :

This is a senior-level position requiring a deep understanding of database technologies and a proven track record of successfully managing and optimizing database systems in enterprise environments.
The Senior Application DBA will work closely with software development teams, system administrators, and business stakeholders to support the organization's strategic objectives through effective database management and optimization.
This role may involve occasional after-hours support and participation in on-call rotations to address critical database issues and perform maintenance activities outside of regular business hours.

---