We are seeking a highly skilled and experienced Senior Database Administrator (DBA) to join our growing team. As a Senior DBA, you will be responsible for ensuring the availability, performance, security, and reliability of our databases. You will lead the architecture, design, implementation, and maintenance of database systems across various platforms and environments. In addition to your technical expertise, you will mentor junior team members, optimize database performance, troubleshoot complex issues, and collaborate with cross-functional teams to ensure database solutions meet business needs.

Key Responsibilities:

• Database Administration:
  • Manage and maintain databases (Oracle, MS SQL, PostgreSQL, MySQL, etc.) ensuring high availability, scalability, and security.
  • Install, configure, and upgrade database instances and patches across all environments.
  • Perform regular database backups and recoveries using tools like RMAN, expdp/impdp, and other enterprise backup solutions.
  • Perform routine database monitoring, troubleshooting, and performance tuning for optimal query execution and reduced latency.
• Database Performance Tuning:
  • Analyze and optimize database performance, including query tuning, indexing strategies, partitioning, and other optimization techniques.
  • Use tools like SQL Profiler, Explain Plans, and custom scripts to diagnose and resolve slow-running queries.
  • Proactively monitor system performance and recommend changes to improve performance and scalability.
• High Availability and Disaster Recovery:
  • Design, implement, and maintain high availability (HA) solutions such as Oracle RAC, Data Guard, and Oracle GoldenGate.
  • Set up and manage disaster recovery environments, ensuring data redundancy, failover procedures, and consistent data integrity across multiple data centers.
  • Coordinate and execute disaster recovery drills and ensure business continuity through regular testing and validation.
• Database Architecture & Design:
  • Collaborate with development and application teams to design scalable and efficient database architectures that meet business requirements.
  • Lead the design and implementation of data models, entity-relationship diagrams (ERDs), and database normalization strategies.
  • Review and propose changes to the database structure to accommodate evolving business needs.
• Cloud Database Management:
  • Manage cloud-based databases such as Amazon RDS, Azure SQL Database, or Google Cloud SQL.
  • Migrate on-premise databases to cloud environments and manage hybrid cloud database architectures.
  • Implement cloud-native database solutions and use modern DevOps tools for automation and scaling (e.g., Kubernetes, Docker).
• Security & Compliance:
  • Implement and enforce database security policies, ensuring compliance with industry regulations and organizational standards (e.g., GDPR, HIPAA).
  • Set up encryption mechanisms, user roles, and audit trails to safeguard sensitive data.
  • Work with security teams to perform regular vulnerability assessments and implement corrective actions.
• Automation & Scripting:
  • Write custom scripts for routine database management tasks (backups, monitoring, reporting) using languages like Python, Shell, or PowerShell.
  • Leverage automation tools such as Ansible, Chef, or Puppet to manage and deploy database configurations.
  • Develop and maintain scripts for database version control using tools like Liquibase or Flyway.
• Migration & Upgrades:
  • Plan and execute database migrations between versions and across different RDBMS platforms (e.g., Oracle to MS SQL, MS SQL to PostgreSQL).
  • Lead database upgrades and patch management across multiple database environments.
  • Ensure minimal downtime during migrations and upgrades and test for functionality post-migration.
• Monitoring & Reporting:
  • Use monitoring tools (e.g., Prometheus, Grafana, Nagios, New Relic) to proactively monitor the health and performance of databases.
  • Establish alerts and set up centralized logging for database health and security monitoring using tools like Splunk or similar.
  • Generate regular performance reports and capacity planning insights to anticipate future resource needs.
• Collaboration & Mentoring:
  • Mentor and provide technical guidance to junior database administrators and developers.
  • Collaborate with application developers, system administrators, and other IT teams to design and support database-driven applications.
  • Share knowledge on database best practices and promote a culture of continuous improvement within the team.

Required Skills & Experience:

• Minimum Experience: 5+ years of experience in database administration, database architecture, and performance tuning in production environments.
• Advanced Database Skills:
  • Expertise in Oracle (19c and higher), MS SQL Server, PostgreSQL, and MySQL.
  • Strong understanding of database design, normalization, and query optimization.
  • Experience in managing Oracle RAC, Data Guard, GoldenGate, and other HA/DR solutions.
• Cloud Database Management:
  • Experience with cloud-based database platforms such as AWS RDS, Azure SQL Database, Google Cloud SQL, and Cloud-native databases.
  • Experience in migrating on-premise databases to the cloud and managing hybrid cloud environments.
• Database Security:
  • Proficiency in implementing database security best practices, including encryption, access controls, auditing, and compliance.
• Scripting & Automation:
  • Proficiency in scripting languages such as Python, Shell scripting, PowerShell for automation.
  • Familiarity with automation tools like Ansible, Puppet, or Chef.
• Performance Tuning:
  • Advanced skills in performance tuning, including query optimization, indexing, and storage management.
  • Experience with SQL Profiler, Explain Plans, and other query analysis tools.
• Disaster Recovery & Backup:
  • Strong experience in setting up and managing backup and recovery solutions, including RMAN, expdp/impdp, and third-party backup solutions.
  • Familiarity with advanced disaster recovery configurations such as Oracle RAC and Data Guard.
• Tools & Technologies:
  • Experience with monitoring tools (e.g., Prometheus, Grafana, Nagios).
  • Familiarity with version control systems (e.g., Git) and database versioning tools like Liquibase or Flyway.
• Leadership & Mentorship:
  • Proven ability to lead a team and mentor junior DBAs and developers.
  • Strong collaboration and communication skills across cross-functional teams.

Preferred Skills:

• Experience with big data technologies such as Hadoop, Spark, or NoSQL databases like Cassandra or MongoDB.
• Experience with in-memory databases like Redis or Memcached.
• Familiarity with containerization and orchestration tools such as Docker and Kubernetes for managing database environments.
• Certifications such as Oracle DBA, Microsoft SQL Server certifications, or cloud certifications (AWS, Azure, Google Cloud) are a plus.

Education:

• A Bachelor’s degree in Computer Science, Information Technology, or a related field.

Other Benefits:

• Weekly Holiday: 2 Days
• Festival Bonus: 2
• Salary review: Yearly
• Mobile Allowance
• Scope for Professional Development & Career Growth
• Health Insurance
• Friendly Work Environment
• Other perks as per Company Policy

Application Deadline: December 12, 2024

Application Procedure: Interested and potential candidates fulfilling the above criteria are requested to apply through Apply Now .