Database Administrator
Zensar
Database Administrator
Zensar
Global IT services for digital transformation
The SQL Server Database Administrator (DBA) is responsible for the design, implementation, maintenance, and optimization of Microsoft SQL Server databases. The role involves ensuring the availability, security, performance, and integrity of databases, as well as collaborating with development teams and other IT professionals to deliver efficient database solutions.
· 5+ years of hands-on database administration experience, with strong production support experience in Microsoft SQL Server and PostgreSQL.
· Administer and support managed PostgreSQL database services across Azure Database for PostgreSQL Flexible Server, Amazon RDS for PostgreSQL, and Amazon Aurora PostgreSQL-Compatible Edition in development, testing, staging, disaster recovery, and production environments.
· Provision and configure PostgreSQL managed instances and clusters, including compute tiers, instance classes, storage, IOPS, server parameters, parameter groups, extensions, maintenance windows, and database configurations.
· Plan and execute PostgreSQL migrations from on-premises environments or other cloud platforms to Azure Database for PostgreSQL, Amazon RDS for PostgreSQL, or Amazon Aurora PostgreSQL.
· Support migrations using native PostgreSQL tools and approved services such as Azure Database Migration Service and AWS Database Migration Service, including assessment, replication, cutover, rollback, and post-migration validation.
· Plan and perform PostgreSQL minor-version maintenance and major-version upgrades, including compatibility assessment, extension validation, application testing, rollback planning, and post-upgrade verification.
· Support Aurora-specific change and upgrade activities using cloning, Blue/Green Deployments, controlled failover, or other approved deployment methods.
· Configure and manage Azure read replicas, Amazon RDS read replicas, Aurora Replicas, reader endpoints, custom endpoints, replica auto-scaling, and failover priorities.
· Demonstrated experience supporting both on-premises and Microsoft Azure database environments.
· Strong knowledge of database architecture, high availability, disaster recovery, backup and recovery, security, performance tuning, and capacity planning.
· Experience working in ITIL-aligned incident, problem, change, release, and service-management processes.
· Ability to manage priorities during production incidents and communicate clearly with technical teams, leadership, and business stakeholders.
· Bachelor’s degree in computer science, Information Technology, Engineering, or equivalent practical experience.
· Relevant Microsoft Azure, SQL Server, or PostgreSQL certification is preferred.
Digital solutions and IT services company that partners with global organizations to drive digital transformation. Its offerings include intelligent automation, analytics, hyperconverged infrastructure, and digital application development and maintenance, delivered through long-term contracts, project-based engagements, and managed services. Indigo Slate handles virtual event creation. Zensar’s Living AI integrates artificial intelligence into business processes to boost outcomes. Unlike many competitors, it emphasizes reducing capital expenditure (Capex) and operating expenditure (Opex), simplifying vendor management, and improving efficiency through automation. The overall goal is to help clients adapt to the digital landscape, optimize technology infrastructure, and achieve higher operational efficiency.
Explore more opportunities at Zensar