Job Summary
As a Database Administrator, you will play a crucial role in managing and optimizing our SQL Server and Postgres databases within a fast-paced cloud environment. You’ll work closely with both our Cloud Management and Solutions teams, providing hands-on support for database configuration, maintenance, performance tuning, and troubleshooting. You will be the go-to expert for ensuring database integrity, security, and performance, while also collaborating with other teams to enable efficient application deployment and data management.
What You’ll Do
- Database Management & Optimization:
- Administer and maintain SQL Server and Postgres databases for cloud-based applications.
- Ensure data integrity, availability, and security across all databases.
- Tune and optimize database performance through effective monitoring and troubleshooting.
- Leverage cloud-native automation tools and scripts to optimize database management, ensuring efficiency and reducing manual intervention.
- Collaboration with Development Teams:
- Work directly with development teams to support database design, query optimization, and data integration in application development.
- Provide technical guidance on database-related tasks, ensuring seamless integration with applications.
- Routine Maintenance & Backups:
- Perform regular database backups, restores, and disaster recovery operations to ensure continuity.
- Schedule and implement preventive maintenance tasks to keep databases secure and optimized.
- Problem-Solving & Issue Resolution:
- Diagnose and resolve complex database performance issues, ensuring minimal downtime.
- Provide hands-on support for database troubleshooting and resolution of incidents in a timely manner.
- Database Upgrades & Patching:
- Plan and execute database upgrades and patching to keep systems up to date.
- Work with cross-functional teams to coordinate downtime and ensure smooth updates.
- Collaboration with Customer Solutions Team:
- Support the Customer Solutions team with database configurations and changes for new and existing cloud applications.
- Assist with infrastructure planning, scaling, and maintenance for databases in cloud environments.
- Documentation & Reporting:
- Create detailed documentation for database configurations, changes, and procedures.
- Report on database health, performance metrics, and any incidents to both teams.
What You’ll Need
- Minimum of 7 years of experience in database administration, with hands-on expertise in SQL Server and Postgres.
- Hands-on experience with cloud services such as AWS RDS, Azure SQL, and Google Cloud Spanner for deploying and managing databases in the cloud.
- Proficiency in scripting languages like Python, PowerShell, Bash, or other automation tools used for database management, backups, and performance optimization.
- Experience working with Docker for database management and creation.
- Deep expertise in managing, optimizing, and troubleshooting SQL Server and Postgres databases.
- Solid experience in database performance tuning, query optimization, and data migration.
- Strong analytical and problem-solving skills with a proactive approach.
- Ability to break down complex technical concepts and clearly communicate solutions to both technical and non-technical stakeholders.
- Ability to work in a fast-paced environment.
- Availability to work in the split shift timings.
- Proven ability to collaborate with cross-functional teams (Development, Solutions) to ensure seamless operations.
- Strong verbal and written communication skills for effective reporting and documentation.
- Commitment to providing exceptional support to internal teams and stakeholders.
