SQL DBA L4 - TechDigital
Jersey City, NJ
About the Job
Key skills to look at(Must have)
Good to have: Database knowledge/expertise on MySQL/ PostgreSQL, RedShift, Snowflake, Oracle etc..
Mandatory skills - SQL Server administration required skills :
Certifications Desired : MS certifications on MSSQL latest versions or AWS/Azure
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
- 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
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 Azure
Experience with Snow Flake
Experience in PowerBI
Certifications Desired : MS certifications on MSSQL latest versions or AWS/Azure
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 : TechDigital