Previous Job
Previous
SQL server & Mongo DB
Ref No.: 17-00320
Location: Dallas, Texas
Position Type:Direct Placement
Start Date: 03/30/2017
SQL server & Mongo DB JOB DESCRIPTION
Responsibilities:
SQL Server DBA:
  • Strong experience in Database Administration in SQL Server (2014, 2012 and 2008R2)
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
  • Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
  • Expert experience in implementing operational automation.
  • Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
  • Knowledge of SQL Server tools ( Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs)
  • 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.
  • Documentation skills for processes and procedures ( creating KBs, runbooks, topology etc )
  • SQL Database Operational support to tech users
  • 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.
  • Experience in developing Capacity Planning Reports and involved in SQL Server Consolidation projects
  • Experience in Automating Administration tasks and Database Maintenance Tasks.
  • Support SQL Reporting Services

Mongo DB:
  • This position will be responsible for implementation and support of the Enterprise MongoDB environment, including; design, capacity planning, shard and replica set up, performance tuning, monitoring, infrastructure planning, scale up/out and administration.
  • Product Installation, Upgradation
  • Creating databases
  • Creating schema / and other objects (tables, views)
  • Granting permissions to
  • Monitor MongoDB cluster connectivity and security
  • Manage and review MongoDB log files
  • File system management and monitoring
Required Qualifications:
  • Solid development or operational IT experience
  • Experience supporting large/complex systems
  • On-Call rotation availability
  • 9+ years of SQL Server experience
  • SQL Server 2012r2 and SQL Server 2016 experience
  • Very Large Database (VLDB) experience
  • SQL Mirroring experience
  • SQL clustering and mirroring experience.
  • Experience supporting high availability systems.
  • 4 years mongo DB administrator experience.
  • Weekend support and on call support
  • Onshore /Offshore Co-ordination