Postgres Db Admin

Mandatory Skills: MySQL, Postgres, Aurora DB, AWS RDS, MSSQL, AWS EC2, CloudWatch

Required strong experience with AWS RDS (MySql, Aurora, MariaDB), MySQL, Postgres, MSSQL

Experience with using AWS EC2, RDS, Aurora, AWS DMS a must

Knowledge of different replication and clustering strategies and experience setting up replication between 2 or more hosts across Regions and Datacenters.

Experience in setting up highly-availability solutions for load balancing, connection pooling, and query partitioning.

Performance tuning skills; understanding of SQL Execution Plans

Ability to proactively identify, troubleshoot and resolve live database systems issues

Experience with automating tasks deployments and patching

Experience with monitoring database system performance using Enterprise monitoring tools CloudWatch Datadog Zabbix

Strategies for performant and non impactful backup restore of high volume live site DBs

Strong experience with relational database management systems with a focus on MSSQL Server Always On and AWS services

Expertise in relational database administration including configuration implementation data modeling maintenance redundancy HA security troubleshooting performance tuning upgrades database data and server migrations SQL

Expertise in configuring implementing and supporting high availability redundancy strategies on systems including replication clustering log shipping mirroring

Expertise with Disaster Recovery planning and implementation

Demonstrated experience with troubleshooting systems issues and effectively diagnosing problems

Good to have Knowledge

Knowledge of hardware EBS Cloud storage RAID and disk subsystems technologies as they pertain to DBMS systems familiarity with SAN technologies desired

Experience with relevant scripting languages or programming frameworks desired powershell shell Linux bash etc

Knowledge of understanding of TCP IP fundamentals DNS FTP SSH general networking technologies AWS VPC stack network architecture and connectivity troubleshooting

Architect and implement Security Compliance across all data platforms. PCI PII

Knowledge in Cloud Computing Internet Security Hardware systems Networking systems Storage technologies.

**About Virtusa**

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 30,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.

Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.

Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.