Database Administration: Install, configure, administer, and maintain Oracle and Microsoft SQL Server databases across development, testing, and production environments.
Performance Tuning and Optimization: Proactively monitor database performance, identify bottlenecks, and implement effective tuning strategies to ensure optimal responsiveness and efficiency.
Backup and Recovery: Develop, implement, and test comprehensive backup and recovery strategies to ensure data integrity and business continuity.
Security Management: Implement and enforce database security policies, including user access control, auditing, and data encryption, in compliance with industry best practices and regulatory requirements.
High Availability and Disaster Recovery: Design, implement, and maintain high availability (HA) and disaster recovery (DR) solutions for both Oracle and SQL Server environments in VMware, AWS, and Azure.
Cloud Database Management: Provision, configure, and manage cloud-based database services (e.g., Amazon RDS, Azure SQL Database, Oracle Cloud Infrastructure) and understand their specific features and limitations.
Database Migrations and Upgrades: Plan and execute database migrations, upgrades, and patching activities with minimal disruption to business operations.
Capacity Planning: Monitor database growth trends and proactively plan for future capacity needs to ensure adequate resources are available.
Troubleshooting and Problem Solving: Diagnose and resolve complex database-related issues in a timely and efficient manner.
Automation and Scripting: Develop and maintain scripts (e.g., SQL, Shell, PowerShell, Python) to automate routine database tasks and improve operational efficiency.
Collaboration and Communication: Work closely with development teams, system administrators, and other stakeholders to provide database expertise and support application deployments.
Documentation: Create and maintain comprehensive documentation for database configurations, procedures, and best practices.
Staying Current: Continuously learn and adopt new database technologies and best practices.
Qualifications
Bachelor's degree in Computer Science, Information Technology, or a related field.
Minimum of 5 years of hands-on experience as a Database Administrator managing both Oracle and Microsoft SQL Server environments.
Proven experience working with databases in VMware virtualized environments.
Significant experience with cloud-based database services on AWS (e.g., RDS, Aurora) and/or Azure (e.g., Azure SQL Database, Managed Instances).
Strong understanding of database principles, architecture, and best practices.
Expertise in performance tuning and optimization techniques for both Oracle and SQL Server.
Solid experience with backup and recovery strategies and tools.
Proficiency in implementing and maintaining database security measures.
Experience in designing and implementing high availability and disaster recovery solutions.