SQL DBA Level 4 - Jersey City NJ - 1447420BR - Resource Logistics, Inc.
Jersey City, NJ
About the Job
- Must have 15+ years of IT experience .
- Must have extensive experience working in large environment .
- Big financial customers domain experience is a plus.
- Extensive and very strong performance tuning .
- Must have strong experience in automation scripts .
Please talk to the candidates as per below skills do not submit if they don t have any skills.
Key skills to look at( Must have):
- Query optimization and performance troubleshooting 5 to 8 years of experience
- Experience working on large databases size between 10TB to 30 TB
- Very good knowledge of MSSQL server internals
- Hands-on experience working with table partitioning and maintenance (expert)
- HA/DR good hands-on experience troubleshooting Always ON and clustering
- Automation: PowerShell / Python / T-SQL ( 8 /10 at least) worked on automation projects
Secondary Skills:
- At least 6 months of AWS RDS experience
Good to have:
- Database knowledge/expertise on MySQL/ PostgreSQL, RedShift, Snowflake, Oracle etc..
Mandatory skills - SQL Server administration required skills |
Knowledge on AWS Cloud services like RDS, S3, Redshift etc MySQL/PostgresSQL knowledge / experience. Linux Knowledge. Experience with Clienture Experience with Snow Flake Experience in PowerBI |
Certifications Desired |
" MS certifications on MSSQL latest versions or AWS/Clienture
Responsibility :
- Ability to think about a problem, identify what we have and implement solutions to solve the problem independently
- Work with onsite client team / Application owners in US / UK to Migrate Applications, Database building and Decommissioning
- Ability to take lead on some projects and works as part of a team (follow another leader on others)
- Strong verbal and written communication skills
- Ability to think in and out of the box. Come up with service improvement ideas and innovative solutions.
- Self-motivated, conscientious, dedicated individual who works equally well independently or as a member of a team
- Must be willing to take responsibility and ownership instead of waiting to be assigned work
- The candidate must be willing to provide On-call and weekend support for SQL and MYSQL, the support is rotated among DBA's in US and India
- Enable and support the team in resolving day-to-day production issues, application upgrades and patches, performance analysis, disaster recovery implementation, capacity planning and other activities as may be necessary.
- Work on Change implementations during UK, US business hours & weekends as per change management process
- Documentation & Operational performance reporting
- Own Service Improvements
- Execute on demand IT projects
- Drive compliance to client and organization processes and policies
- Ensure Quality of deliverables
Source : Resource Logistics, Inc.