At Synoptek, we think globally and act locally. As the world's first Managed Experience Provider (MxP™), Synoptek provides world-class strategic IT leadership and hyper-efficient IT operational support, enabling our global client base to grow and transform their businesses. We are excited to have experienced continuous growth and, in keeping with that momentum, we are seeking to add talent to our team.

When you partner with Synoptek, you engage with an ever-growing, ever-evolving IT organization that provides a high-caliber team, drives growth, and delivers clarity. This is an exciting opportunity for you to be a part of this journey!!

The Database Administrator IV is responsible for working with customers, developers, and application teams to determine database requirements, architect database solutions, design schemas, maintain stored procedures, views, and indexes, and ensure stable, secure, and high-performing database operations. This role supports SQL Server installation, upgrades, migrations, configuration, performance monitoring, database maintenance, security administration, backups, restores, high availability design, and 24/7 operational support. The position also serves as a senior technical resource for database assessments, sales support, project estimation, performance troubleshooting, and DBA team mentorship.

Mandatory Skills

Database Administration,DBA,SQL Server,MSSQL,SQL Server Installation,SQL Server Upgrades,SQL Server Migrations,SQL Server Configuration,Database Architecture,Database Design,Schema Design,Stored Procedures,Views,Indexes,Query Throughput Monitoring,Database Performance Monitoring,Database Storage Management,Database Maintenance Plans,Database Security Access,Database Backups,Database Restores,Database Connectivity Troubleshooting,Change Management,MSSQL Alert Tickets,High Availability,SQL Code Optimization,Database Assessments,Performance Troubleshooting,Developer Collaboration,Application Team Support,DBA Mentoring,Communication Skills

Role

- Administer, monitor, and support multiple Azure Database for PostgreSQL environments, including Flexible Server and Single Server where applicable.
- Manage database provisioning, configuration, patching, upgrades, backups, restores, and disaster recovery.
- Design and maintain high-availability and resiliency strategies using Azure-native capabilities.
- Manage vacuum strategies, index optimization, statistics maintenance, and database-bloat reduction.
- Diagnose and resolve slow queries, lock contention, memory pressure, connection exhaustion, and availability issues.
- Analyze query execution plans and optimize SQL, indexes, and schema designs.
- Establish performance baselines and capacity plans to support application growth.
- Design, configure, deploy, tune, and operate PgBouncer in Azure-based environments.
- Select and manage appropriate PgBouncer pooling modes, connection limits, pool sizes, authentication, TLS, and timeout settings.
- Troubleshoot connection storms, pool saturation, and application connection-pooling issues.
- Implement role-based access controls, least-privilege access, encryption, auditing, logging, and access reviews.
- Build and maintain monitoring, alerting, and dashboards using Azure Monitor, Log Analytics, and PostgreSQL metrics.
- Automate database operational tasks using scripting and infrastructure-as-code tools.




- Participate in on-call rotations and lead root-cause analysis for database-related incidents.
- Partner with application teams to promote safe client behavior and effective connection pooling.
- Create and maintain runbooks, operational documentation, database standards, and best practices.
- Provide technical guidance to engineering, DevOps, and SRE teams on PostgreSQL reliability, security, scalability, and performance.

Flsa

Exempt EEO Statement:We are proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, veteran status, sexual orientation, gender identity, marital status, pregnancy, genetic information, or any other characteristic protected by law and will not be discriminated against on the basis of disability. It is our intention that all qualified applicants are given equal opportunity and that employment decisions be based on job-related factors.

Location

Ahmedabad, Gujarat, India;Pune, Maharashtra, India

Education Qualification

Bachelor’s

Desirable Skills

Microsoft SQL Server Database Certification,Azure Database Certification,Azure Database,MySQL,Transactional Databases,Cloud Setting,Server Environment,Networking Environment,Proposal Support,Sales Call Support,Project Estimation,Database Recovery,Database Tuning,Database Security,Independent Project Delivery,Technical Documentation,24/7 Database Operations,Customer-Facing Support

Experience

5 to 10 Years

📌 Azure PostgreSQL DBA – India (Maharashtra)
🏢 Synoptek
📍 Maharashtra