Z

Zensar

Global IT services for digital transformation

SQL Server Database Administrator - Sys Admin

Database AdministrationConfirmed live in the last 24 hours
Full-timeIndiaNo salary listedIn-person

About the Job

Requirements

  • Experience managing Microsoft SQL Server databases on-premises and in Azure Managed Instance (PaaS) and IaaS environments.
  • Experience supporting database performance and resolving processing and programming problems.
  • Experience with SQL Server high availability and disaster recovery options.
  • Experience tuning queries and refining database schemas.
  • Experience with SQL Server database upgrades and migrations across versions 2008 through 2022.
  • Experience installing and configuring SQL Server 2016, 2017, and 2019 in clustered and standalone environments.
  • Experience supporting ETL applications and administering, deploying, and troubleshooting SQL Server Integration Services packages.
  • Experience with SQL Server pathing in single-instance and clustered environments.
  • Expertise in database backup and restore operations and executing SQL Server Integration Services packages.
  • Experience monitoring SQL Server performance using SQL Profiler, the Index Tuning Wizard, and Performance Monitor.
  • Experience with replication, Always On availability groups, and clustering, including active/passive and active/active cluster environments.
  • Experience implementing SQL Server security and object permissions, including creating Windows and SQL users, configuring permissions, and assigning user roles.
  • Experience migrating on-premises SQL Server databases to Microsoft Azure-hosted databases.
  • Experience with managed instances, high availability, Always On, log shipping, patching, troubleshooting, and optimization.
  • Experience creating linked servers between on-premises SQL Server and Azure cloud.
  • Experience configuring geo-replication for high availability.
  • Experience designing databases for business applications with scalability, security, performance, and reliability requirements.
  • Experience with software development, scalable data architectures, and design.
  • Experience working in a cloud-based environment, specifically Microsoft Azure.
  • Experience monitoring and tuning databases to provide high availability.
  • Experience in Windows Server environments, including Windows Server 2016, 2019, and 2022.
  • Proficiency with Windows systems, clustering, and scripting.
  • Understanding of distributed systems and parallel-processing architecture.
  • Experience with database security solutions and implementations, including data masking, database activity monitoring, and data encryption.
  • Experience delivering data warehouses and data marts from specification through end-user acceptance testing.
  • Experience with database replication, hot standby, clustering, and table partitioning in on-premises and cloud environments.
  • Experience administering PostgreSQL databases in on-premises Linux and Windows environments and Microsoft Azure, including Azure Database for PostgreSQL Flexible Server and PostgreSQL hosted on Azure virtual machines.
  • Experience installing, configuring, patching, and upgrading PostgreSQL instances, performing minor-version maintenance, and planning major-version upgrades using in-place or logical migration methods.
  • Experience managing PostgreSQL databases, schemas, roles, privileges, authentication, pg_hba.conf, SSL/TLS, parameter configuration, extensions, tablespaces, and connection settings.
  • Experience configuring automated backups, backup-retention periods, manual snapshots, point-in-time recovery, geo-restore, cross-region snapshot copies, and backup-recovery validation for PostgreSQL.
  • Experience configuring and supporting physical streaming replication, read replicas, synchronous and asynchronous replication, replication slots, WAL archiving, and failover solutions such as Patroni, repmgr, or approved enterprise tooling.

Responsibilities

  • Design, implement, maintain, and optimize Microsoft SQL Server databases, ensuring their availability, security, performance, and integrity.
  • Analyze, solve, and correct issues in real time, and provide solution recommendations.
  • Refine and automate regular processes, track issues, and document changes.
  • Provide 24x7 support for critical production systems.
  • Administer Microsoft Azure cloud services day to day.
  • Support business applications and ensure system availability, security, performance, and reliability.
  • Design databases to support business applications and ensure scalability, security, performance, and reliability.
  • Plan and provide administrators with guidance on the frequency of necessary upgrades to enhance database performance.
  • Monitor and interpret system resource consumption trends to ensure production systems meet availability requirements and hardware enhancements are scheduled appropriately.
  • Create and enforce database development standards, preventing and correcting deviations from those standards.
  • Administer PostgreSQL databases and configure their maintenance, security, recovery, replication, and failover capabilities.

About the Company

Zensar

Global IT services for digital transformation

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.

Company size
10,001+
Company stage
IPO
Headquarters
Pune, India
Founded
1991

Recently Posted Jobs

Explore more opportunities at Zensar

See more jobs