Lead the migration of databases from MS SQL to Aurora PostgreSQL, manage database administration, optimize performance, and troubleshoot issues. Collaborate with cross-functional teams for project success.
CSG Forte is seeking an experienced Senior Aurora PostgreSQL Database Administrator (DBA) to join our team. The primary responsibility of this role is to support and assist with the database migration from MS SQL to Aurora PostgreSQL. This senior-level position requires extensive experience in handling complex projects and providing expert guidance and support in Aurora PostgreSQL.
Key Responsibilities:
- Database Migration: Lead and support the migration of databases from MS SQL to Aurora PostgreSQL, ensuring a smooth and efficient transition.
- Administration: Manage and maintain Aurora PostgreSQL databases, including installation, configuration, and upgrades.
- Performance Tuning: Optimize database performance through query optimization, indexing, and resource management.
- Recommendations: Provide expert recommendations on best practices for database design, architecture, and implementation.
- Monitoring and Alerting: Implement and manage monitoring and alerting systems to ensure database health and performance.
- Maintenance: Perform regular maintenance tasks, including backups, recovery, and security measures to ensure data integrity and availability.
- Troubleshooting: Diagnose and resolve database-related issues, providing timely support to development and engineering teams.
- Documentation: Maintain comprehensive documentation of database configurations, procedures, and best practices.
- Collaboration: Work closely with cross-functional teams, including developers, system administrators, and network engineers, to support project requirements and deliver high-quality solutions.
Qualifications:
- Education: Bachelor's degree in Computer Science, Information Technology, or a related field.
- Experience: Minimum of 7 years of experience as a DBA, with at least 3 years of experience specifically in Aurora PostgreSQL.
- Technical Skills: Proficiency in Aurora PostgreSQL, including installation, configuration, performance tuning, and backup/recovery. Knowledge of SQL and PL/pgSQL. Familiarity with database security best practices.
- Problem-Solving: Strong analytical and troubleshooting skills, with the ability to diagnose and resolve complex database issues.
- Communication: Excellent verbal and written communication skills, with the ability to collaborate effectively with team members and stakeholders.
- Certifications: PostgreSQL certification is a plus.
Preferred Qualifications:
- Experience with cloud-based database solutions (e.g., AWS RDS).
- Knowledge of other database systems (e.g., MS SQL, MySQL, Oracle).
- Familiarity with DevOps practices and tools (e.g., Docker, Kubernetes).
- Experience with automation and scripting (e.g., Python, Bash).
Location(s):
India RemoteTop Skills
Aurora Postgresql
Aws Rds
Bash
Docker
Kubernetes
Ms Sql
Pl/Pgsql
Python
SQL
Similar Jobs
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
As a Senior Database Engineer at Motive, you will ensure the performance, reliability, and scalability of over 100 databases with a focus on PostgreSQL. Responsibilities include designing high availability architectures on AWS, empowering developers, optimizing queries, automating database tasks, and overseeing database security, upgrades, and maintenance, while achieving high service level agreements.
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The role involves building high-quality software, mentoring colleagues, and implementing features while collaborating with product owners to fulfill detailed requirements.
Top Skills:
AngularJavaJavaScriptReactVue
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Senior Software Engineer will create high-quality code, collaborate with product owners, implement software solutions, and mentor colleagues.
Top Skills:
AIAngularJavaJavaScriptReactVue
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
