Job Description :
Job Title: SQL DBA - USC, GC, EAD on W2 only

Job Location: Dallas, TX

Duration: 6 montha

Experience: 6 Years

Mandatory Skills:

Installing, configuring, administering and securing SQL Server databases through

multiple product lifecycle environments, from development to mission-critical production

systems.

Database backup and disaster recovery procedures.

Implementing and administering high availability set up through always on, cluster,

Mirroring and replication

Experience in database migration and upgrade.

Experience in query optimization & performance tuning using SQL Profiler, Execution

Plan, Performance Monitor and DBCC Commands

Experience in creating jobs to automate repetitive tasks using SQL agent jobs and SSIS

packages.

Maintain data integrity and security (manage roles and permissions of database users

Refine and automate regular processes, track issues, and document changes

Tracking frequently occurring issues and fixing them to closure

Monitor the database queues and alerts, make sure they are picked in time and worked

upon

Work on project reports (Weekly/Monthly) and DE items as required

Experience with TSM Backup and Restores

Should be able to create MongoDB collections and documents

Experience in Installation, Configuration and Administration of MongoDB in Red Hat.

Experience working with large number of Replica sets – multi node production clusters

Experience in MongoDB backup and recovery procedures

Experience in MongoDB data modeling, schema

Experience in MongoDB troubleshooting