ESaaS - DBA - Sys Admin

Zensar Technologies

Not disclosedIndia (On-site)
Posted: 13d agoOpening: 1

Skills Required

Key skills are marked withstar
  • Key skillPostgreSQL
  • Key skillDatabase Administration
  • Key skillReplication
  • Performance Tuning
  • Query Optimization
  • Backup & Recovery
  • High Availability
  • Patroni
  • pgBouncer
  • Linux
  • Shell Scripting
  • Amazon RDS
  • Monitoring Tools
  • Database Security
  • Upgrades & Migrations

Job Description

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.

  • Should have MSSQL DBA experience managing On-prem and cloud Azure MI PAAS, IAAS SQL server databases 
  • Experience supporting database performance, evaluating and resolving processing and programming problems
  • Analyze, solve, and correct issues in real time
  • Provide suggestions for solutions
  • Good experience on High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with query tuning and schema refinement
  • Provide 24x7 support for critical production systems
  • Microsoft Azure cloud day to day administration. 
  • Upgrade and Migration of databases from SQL Server   2008/2008r2/2012/2014/2016/2019/2022.
  • Experience in working with programmers and assisting in optimizing databases for operational and performance efficiency
  • Installation and configuration of SQL server 2016/2017/2019 in cluster and standalone environment.
  • Support business applications, ensuring system availability, security, performance and reliability.
  • ETL application support, SSIS package administration/deployment/troubleshooting 
  • SQL server pathing on single instance and cluster environments. 
  • Expert level skills in Backup and restore database operations and executing SSIS packages
  • Monitoring SQL server performance using SQL Profiler, INDEX tuning wizard and performance monitor.
  • Replication, Always on availability groups and clustering 
  • Experience working in Active/Passive. Active/active cluster environment.
  • Implementation of SQL Server security and Object permissions like maintaining creation of users (Windows and SQL), configuring permissions, and assigning roles to users.
  • Migrate on -prem SQL server database to Microsoft Azure hosted DB’s.
  • Managed instances, High availability, always on, Log shipping, patching, Troubleshooting and optimization. 
  • Link server create from On-prem to Azure cloud.  
  • Configure geo replications for High availability. 
  • Design databases to support business applications, ensuring system scalability, security, performance, and reliability
  • Plan and provide guidance to administrator regarding frequency of necessary upgrades to enhance database performance
  • Monitor and interpret systems 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 any deviations from database development standards
  • Excellent problem solving, time management, communications, and presentation skills
  • Excellent consulting, analytical and communications skills
  • Strong communication and organizing skills, and proven ability to interact and influence other technical leaders/architects in a collaborative fashion
  • Experience in software development with demonstrated experience in scalable data architectures and design
  • Problem solving / analytical skills, tools, and techniques
  • Experience working in a Cloud based environment. Specifically, with Azure
  • Experience in monitoring and tuning a database to provide a high availability service
  • Experience working in Windows Server environments including Windows 2016/2019/2022
  • Strong Windows systems, clustering and scripting proficiency
  • Good understanding of Distributed Systems and Parallel Processing architecture
  • Experience with Database Security solutions and implementations (Data Masking, Database activity monitoring, Data Encryption)
  • Experience delivering data warehouse/marts from specification through end-user acceptance testing
  • Experience with database replication, hot stand-by, clustering, and table partitioning on -prem and cloud
  • PostgreSQL Administration
  • Administer PostgreSQL databases in on-premises Linux/Windows environments and Microsoft Azure, including Azure Database for PostgreSQL - Flexible Server and PostgreSQL hosted on Azure VMs.

  • · Install, configure, patch, and upgrade PostgreSQL instances; perform minor-version maintenance and plan major-version upgrades using suitable in-place or logical migration methods.

  • · Manage databases, schemas, roles, privileges, authentication, pg_hba.conf, SSL/TLS, parameter configuration, extensions, tablespaces, and connection settings.

  • · Configure automated backups, backup-retention periods, manual snapshots, point-in-time recovery, geo-restore, cross-region snapshot copies, and backup-recovery validation.

  • · Configure and support physical streaming replication, read replicas, synchronous/asynchronous replication, replication slots, WAL archiving, and failover solutions such as Patroni, repmgr, or approved enterprise tooling.

 

Similar Jobs (35111)

Senior Verification Engineer | High-Performance Computing & Graphics

AMD

Not disclosedHyderabad

Skills required:

High Performance Computing, Parallel Computing, MPI, OpenMP, C++, CUDA, Linux, Slurm, Cluster Management, Performance Optimization, Python, Fortran, GPU Programming, Shell Scripting, Networking

Application Tech Support Practitioner

Accenture

Not disclosedBengaluru

Skills required:

Cloud Platforms, AWS, Microsoft Azure, Troubleshooting, Linux, Networking, Cloud Monitoring, Customer Support, Incident Management, Shell Scripting, Python, Identity & Access Management, Cloud Databases, Ticketing Systems, Root Cause Analysis

Product Manager

TriNet

Not disclosedHyderabad

Skills required:

Product Management, Product Roadmapping, Product Strategy, User Research, Requirements Gathering, User Stories, Agile Methodologies, Product Analytics, A/B Testing, Stakeholder Management, Go-to-Market Strategy, Prioritization Frameworks, Data Analysis, Wireframing, Jira

Principal Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Programming, Scalability, Design Patterns, Cloud Architecture, Performance Optimization, Microservices, Code Review, Mentoring, Technology Strategy, Security Best Practices, Cross-Functional Collaboration

Staff Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Scalability, Programming, Cloud Architecture, Microservices, Performance Optimization, Cross-Team Collaboration, Mentoring, Code Review, Technology Strategy, Security Best Practices

Staff Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Scalability, Programming, Cloud Architecture, Microservices, Performance Optimization, Cross-Team Collaboration, Mentoring, Code Review, Technology Strategy, Security Best Practices

Manager, Enterprise Data Management

TriNet

Not disclosedHyderabad

Skills required:

Data Management, Data Quality, Data Governance, Master Data Management, SQL, Excel, Data Cleansing, Data Validation, Data Profiling, Metadata Management, Documentation, Reporting, Attention to Detail

Principal Software Engineer

TriNet

Not disclosedHyderabad

Skills required:

Software Architecture, System Design, Distributed Systems, Technical Leadership, Programming, Scalability, Design Patterns, Cloud Architecture, Performance Optimization, Microservices, Code Review, Mentoring, Technology Strategy, Security Best Practices, Cross-Functional Collaboration

AI Native Software Engineer

Accenture

Not disclosedBengaluru

Skills required:

Artificial Intelligence, Machine Learning, Python, Large Language Models, Deep Learning, PyTorch, TensorFlow, Retrieval-Augmented Generation, Prompt Engineering, Natural Language Processing, MLOps, Model Deployment, Vector Databases, REST APIs, Docker

I&P GN - I&E - Comms & Media - Consultant - Process Excellence-PE

Accenture

Not disclosedBengaluru

Skills required:

Process Excellence, Lean Six Sigma, Process Redesign, Process Mapping, Value Stream Mapping, Root Cause Analysis, KPI Development, Change Management, Automation Opportunity Analysis, Client Management, Training Delivery, Presentation Skills

View All 35111 Jobs