Hello,
This is Pavan from ITech US inc. Given below are the details of the position with one of our clients and was wondering if you would be interested or can recommend someone who would be interested in this job.
Role: SQL DBA Consultant
Location: Tampa, FL (Onsite)
Duration: 9+ Months Contract
Client: TCS
NOTE: NEED FOR LOCALS ONLY.
Role Description:
- The primary responsibilities of this role include owning, tracking, and resolving Microsoft SQL Server, PostgreSQL DB, MySQL and MongoDB instances and databases related issues. This position involves with analyzing and setting up the infrastructure based on the project requirements. Reviewing service related reports (e.g. database backups, maintenance, and 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 the different teams to come up with strategic solutions on unknown issues.
- This MS SQL Server DBA role requires a team centric service oriented mentality, high sense of ownership of the problems and requests assigned, focus on managing and resolving issues, establishing and maintaining communication with technology customers to keep them updated with the status of the requests, initiating and performing changes on production systems, and proactively escalating any issues that cannot be resolved within the established timeframes.
POSITION REQUIREMENTS:
- More than 5 years of experience in Database Administration for SQL Server (2008R2/2012/2014/2016/2017) in a multi-site enterprise environment.
- At least 5 years of hands-on experience in PostgreSQL & MySQL Database Administration/ Engineering
- Knowledge of MongoDB, SQL on Hadoop, SYBASE, Oracle is a big plus
- Must have experience on On-premise, AZURE IaaS, PaaS instances.
- Strong experience on analyzing and migrating the infrastructure (including the application and database instances) from On-premise to Azure cloud infrastructure.
- Must have experience on analyzing the infrastructure to set up the environments as per the defined project scope.
- Strong experience in troubleshooting and resolving SQL Server instances and related technologies integrations and database problems.
- Should be strong on analyzing the application and database connectivity issues including the drivers and protocols used.
- Must have experience configuring and managing SQL Server clusters, Availability Groups and Always On.
- Strong experience in Performance Tuning and Optimization (PTO) of SQL Server databases, using native monitoring and troubleshooting tools.
- Must have experience with backups, restores and recovery models for SQL Server.
- Must have experience with SQL Server Replication.
- Must have strong experience on security models (In-transit, data-at-rest, On-fly encryptions) based on data classifications.
- Strong experience on High Availability (HA) and Disaster Recovery (DR) options for SQL Server, including AlwaysOn Availability groups, SRM cluster etc.
- Must have experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
- Must have experience in implementing operational automation using scripts.
- Must have experience in how indexes are used, missing indexes, index management, type of fragmentations.
Education: At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required.
Thanks & Regards,
Pavan Yantrapati,
Email: [email protected]
iTech IT Solutions Private Limited | www.iTechUS.com
PH: +1 904-242-1993 Ext 352
|
| |
|