Logo
Omni Inclusive

SQL DBA Level 4

Omni Inclusive, Jersey City, New Jersey, United States, 07390


Must have

12+ 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 experienceExperience working on large databases size between 10TB to 30 TBVery good knowledge of MSSQL server internalsHands-on experience working with table partitioning and maintenance (expert)HA/DR good hands-on experience troubleshooting Always ON and clusteringAutomation: 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 etcMySQL/PostgresSQL knowledge / experience.Linux Knowledge.Experience with AzureExperience with Snow FlakeExperience 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 independentlyWork with onsite client team / Application owners in US / UK to Migrate Applications, Database building and DecommissioningAbility to take lead on some projects and works as part of a team (follow another leader on others)Strong verbal and written communication skillsAbility 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 teamMust be willing to take responsibility and ownership instead of waiting to be assigned workThe 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 IndiaEnable 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 processDocumentation & Operational performance reportingOwn Service ImprovementsExecute on demand IT projectsDrive compliance to client and organization processes and policiesEnsure Quality of deliverables