SQL Server DBA

 
Location: Plano, Texas
Posted On: 10/11/2017
Job Code: 2165_SSD_TX
Print
 
Job Description
 
Job Title: SQL Server DBA
Lob Location: Plano, TX
Duration: 6+ months (High probability of extension after that)

Position Details:
Responsible for the design, development and administration of transactional and analytical data constructs/structures. Included within those responsibilities are the areas of data access and delivery technologies. Includes SQL Server, PostGreSQL, DB2. Duties include performance tuning, monitoring, software installs and upgrades, UNIX shell scripting, and physical and logical database design.
• Responsible for administration and maintenance of SQL Server (2012 and above) databases for several applications in multiple environments
• Must have experience in configuring and maintaining database servers, creating new databases, following best practices in SQL Administration and development
• Must have used and have a very good understanding of SQL server monitoring, SQL comparison and deployment tools
• Must have worked and deployed SQL scripts in Dev, QA, Prod environments and have used database CI tools
• Ensure the SQL server database schemas are in synch in Dev, QA and Prod environments; Build databases for development purposes post production deployment
• Assist multiple application teams in troubleshooting the database issues/errors, tuning database queries, running reports, creating developer databases
• Take ownership of database related adhoc requests, incidents, alerts, escalations and respond and/or resolve in a timely manner
• Take ownership and ensure production deployment scripts are thoroughly tested in staging environment with no errors
• Ensure the high availability of database servers and databases
• Must have a thorough knowledge and working experience of SQL database cluster, have configured Always ON Availability
• Must be experienced to collect the CPU, Memory usage, blocking query reports and troubleshoot and fix the root-cause of the CPU, Memory issues and blocking on a database/server
• Knowledge and experience of Cassandra NoSQL database modeling and operations, PostGreSQL, AWS is preferred but not required
Category:IT  code:new
 
 
Job Requirements
 
 
Choice of closing statement

To apply for this position please send your resume to Chirag Shah at chirag.shah@collabera.com or you can give a call at 804-955-4265.
 

Not Ready to Apply?
Contact Details
 
Recruiter
Chirag Shah
 
Phone
 
E-mail Address
 
LinkedIn