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