Role description

SQL Server DBA

• Perform hands-on technical work to install and configure SQL Server Database on new SQL Server database and integration with backup tools1.
• Proficient in data transfers, setup migration plans, support in existing site for data extraction, data transfer assist, application support for cross Datacenter migrations1.
• Identify and support application teams for MS SQL DB support and decom of instances in existing site during post-migration1.
• Experience in database schema and table refreshes from prod to non-prod with Datapump/export/import utilities1.
• Experience in handling database performance issues with diagnostic tools such as AWR, ADDM, ASH, explain plan, wait events, locks, stats collection, SQL profiling, SQL tuning advisory, creation/rebuild indexes if required1.
• Experience in TDE data encryption1.
• Experience in Goldengate replication setup/configure1.
• Supporting major deployment activities by creating flashback restore points and rollback database to restore point in case of issues in deployment1.
• Configuring server and database monitoring for all servers and databases in OEM1.
• Experience in database migration with RMAN, Datapump, and XTTS method with minimal downtime1.
• Experience in UNIX/LINUX shell scripting and programming1.
• Hands-on experience in working on DR drill activity various times and ensuring that activity is completed perfectly1.
• Configure backup monitoring, housekeeping s, and documentation as part of migration projects1.
• Monitoring the logs for any errors/warnings and providing corrective action if required1.
• Installation of Oracle client in the application server and adding up TNS entries for DB connectivity

Skills

Mandatory Skills : MS SQL

Good to Have Skills : Azure SQL, Windows Server