Job Description :
Hi,

Role: SQL/Mongo DBA
Location: Grapevine, TX
Duration: 12+ month contract.
Mode of interview: Skype


Job Summary:
This is a Senior DBA role largely responsible for providing operational database services related to SQL Server and Mongo DBs footprint. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with other team members to come up with strategic solutions to recurring problems. This person will be regarded as a Subject Matter Expert (SME) for this environment. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills.

Platform Specific Required Skills:
SQL Server:
Ø Strong experience in Database Administration of different SQL Server versions (2014, 2012 and 2008R2
Ø Must have experience running production SQL Server Database Clustered environments including: maintenance, tuning, backup/restore, analysis and troubleshooting.
Ø Working knowledge of database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Ø Working knowledge of index management, integrity checks, configuration. How statistics work, how indexes are stored, how they can be created and managed effectively.
Ø Hands on experience in using SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs
Ø Experience in extracting and transforming data between homogenous and heterogeneous systems using dynamic DTS packages, IMPORT/EXPORT, BULK Insert, BCP and XML Technologies.
Ø Experience in developing DTS Packages and migrating DTS Packages to SSIS Packages.
Ø Working knowledge of SQL Reporting Services.

Mongo DB:
Ø Solid knowledge of MongoDB and other NoSQL database concepts.
Ø Experience in setting up data sharding and replica set.
Ø Hands on experience in mongo db performance tuning, monitoring, infrastructure planning.
Ø Hands on Experience in DB Installation, Upgradation, Patching.
Required Background:
Ø 7-9 years of SQL Server DB Administration experience.
Ø 3-4 years of mongo DB administration experience.

General Required Skills:
Ø Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
Ø Should have good documentation skills for processes and procedures ( creating KBs, runbooks, etc. )
Ø Experience in Automating Administration tasks and Database Maintenance Tasks.
Ø Ability to provide Weekend support and participate in on-call rotation.
Ø Working knowledge of managing Large Database Systems (LDB
Ø Strong interpersonal and communication skills; make presentations to an internal audience, and interact positively with upper management.
Ø Independent problem-solving, self-direction.
Ø Must have ability to teach/mentor/lead other team members.
Ø A natural sense of urgency, ownership, initiative and a positive team player philosophy to be reflected in the daily work ethic.

Desired background and Skills
Ø SQL Development – ability to write and troubleshoot SQL Code and design ( stored procs, functions, tables, views, triggers, indexes, constraints )
Ø Solid acquaintance with windows server, security delegation, SPNs, storage components - Netapp, XIV.
Ø Ability to write and maintain Unix/Linux shell scripts.
Ø Certification in Microsoft SQL and Mongo is a plus.
Ø Working knowledge of high-availability and disaster-recovery solution such as Always On Availability groups, SAN replication, etc.
Ø A degree in computer science or a related field.



Suryansh Purwar | Technical Recruiter | Apetan Consulting LLC
Phone * 160 | Email:- |
Mailing Address: 72 Van Reipen Avenue pmb#255, Jersey City, NJ 07306 |
Corp. Office: 15 Union Avenue, office # 6, Rutherford, New Jersey 07070 |
Web link: |

Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience.
             

Similar Jobs you may be interested in ..