DBA (PostgreSQL +MSSQL)

Qualification: Bachelor’s Degree /any Experience: At least 3 years of hands-on experience in PostgreSQL, MSSQL Database Administration/ Engineering Solid understanding of database design principals Good performance tuning skills and Problem-solving skills Ability to proactively identify, troubleshoot and resolve live database systems issues.

Experience working as Cloud DBA, automation. Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore Experience as a SQL Server DBA or similar role Experience with MY SQL Server Administration experience required Experience with Performance Tuning and Optimization (PTO) Experience with backups, restores and recovery models Experience of High Availability (HA) and Disaster Recovery (DR) options for SQL Server Experience with Windows server, including Active Directory Solid understanding of query execution plans Good SQL scripts skill including SPs, PSQL scripting Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments.

Responsibilities

Install, monitor, and maintain PostgreSQL and MSSQL, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning and assist in business process integration with various data sources. Maintain standby databases, Migrate and upgrade databases. Implement high availability solutions fail-safe db environment with attest 2 DB Servers Should be able to do Point in time recovery.

PostgreSQL Index Management, Partitioning and System Catalogs. Fulfills user requests ranging from access control, backup, restore, refresh to non-production to performance tuning. Provides online & on call coverage for production support and administration. Responsible for ensuring availability and performance of the databases that support the system Monitoring & responding the database systems incidents to ensure secure production services to business Ability to configure DB parameters to optimize its performance.

Write database checks for the alert monitoring system Requirements. Ability to create, update and configure stored procedures, views, tables, index, triggers etc. Need to handle data trouble shooting and maintaining data integrity and security. Support for Development environments Refresh of UAT/Staging/pre-prod environments Database troubleshooting and problem root cause analysis.

Experience in performance monitoring, reporting, and tuning of databases. Planning, implementation and maintaining (Incremental/full and hot) DB Backups Strategies. Work with infrastructure team (co-ordinate with the application support team) to ensure that the associated hardware resources are allocated to the database to ensure high availability and optimum performance.

Proactive Maintenance of the database servers. Good time-management skills. Great interpersonal and communication skill.

Requirements

PostgreSQL, MSSQL DBA skills are essential. Sound operating knowledge on Windows/UNIX / Linux platform. Perform Performance Engineering & Performance Improvement activities Experienced with PostgreSQL & MSSQL Architecture Installation & Configuration. Schema handling. Database user roles and Security related permission.

User creation, object Backup & Restore. Architect level Server security. Creating and Managing PostgreSQL and MSSQL Databases.

Benefits

We do not unfairly discriminate on any ground, including race, caste, religion, color, ancestry, marital status, gender, sexual orientation, age, nationality, ethnic origin, disability or any other category protected by applicable law. Competitive Salary Better Growth Work Life Balance.