Back to results: remote sql server dba / US
Posted on: 08 Mar 2024
Job Location: Port Washington, US
Job Description:
Req ID: 244884
NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.
We are currently seeking a SQL Server DBA - REMOTE to join our team in Port Washington, New York (US-NY), United States (US).
SQL Server Database Engineer
NTT Data is seeking a highly skilled and motivated Database Operations Engineer with expertise in modern database technologies and infrastructure. As a member of our dynamic DBA team, you will be responsible for managing and supporting client database systems, ensuring their availability, scalability, and optimal performance. The ideal candidate possesses a solid technical foundation in database architecture, configuration, provisioning/installation, and maintenance, along with hands-on experience in building and supporting highly available and scalable systems. In addition, you should have a strong understanding of data replication strategies and technologies. This role requires expertise in Microsoft SQL Server, PostgreSQL, and AWS RDS, as well as excellent interpersonal and communication skills.
Job Responsibilities Include:
* Manage and oversee the entire lifecycle of SQL Server databases, from development to mission-critical production systems, including SQL Server clusters, SSIS and SSRS infrastructure.
* Configure, monitor, and maintain database servers and processes to ensure high levels of performance, availability, security, and compliance.
* Perform scheduled maintenance tasks and support release deployment activities outside of regular working hours.
* Provide 24x7 support for critical production systems, promptly addressing any issues that may arise.
* Monitor and troubleshoot database systems, ensuring data integrity, security, and optimal performance.
* Develop and implement strategies for data protection and lifecycle management, including backup and recovery, disaster recovery, data retention, and capacity planning.
* Independently analyze and resolve database issues in real-time, providing end-to-end problem resolution.
* Collaborate with developers to review SQL code for performance, scalability, and security optimizations.
* Analyze indexes and execution plans to identify performance improvements and provide guidance on optimal T-SQL coding standards.
* Assist engineering teams in troubleshooting and optimizing queries, stored procedures, views, and functions to address performance issues.
* Utilize industry best practices and coding techniques to refine operational procedures and processes, ensuring solution reliability.
* Maintain comprehensive documentation of database schema changes, ETL processes, and other relevant information in a SQL Server production environment.
* Evaluate the benefits of new SQL Server features and versions, making recommendations for their adoption when appropriate.
* Create and maintain detailed documentation, including diagrams of the database infrastructure.
* Gain a deep understanding of relevant business processes, data flow, criticality, and dependencies.
* Troubleshoot and develop SSIS packages as needed.
* Collaborate with engineers to create optimized SQL code and provide technical mentorship and cross-training to team members.
Basic Qualifications:
* 10 years of experience in Microsoft SQL Server Database Administration and Engineering.
* Experience with RDBMS concepts, database architecture, and SQL/T-SQL.
* Experience with database security concepts, including data encryption at rest and in transit.
* Experience with SQL Server Profiler for monitoring and troubleshooting database activity and performance.
* Experience with SQL Server Clustering and HA technologies, such as mirroring, log shipping, Always On, block-level replication, and failover clusters.
* Experience with SQL Server change data capture (CDC), SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
* Expertise in T-SQL DDL/DML, including stored procedures, functions, CLR, triggers, cursors, SMO, query plans, hints, partitioning, and OLAP.
* Experience with SQL Server isolation levels, transaction processing, batch processing, lock escalation, and error handling fundamentals.
* Experience writing complex SQL queries involving multiple tables and inner and outer joins.
* Experience with snapshot isolation models in SQL Server.
* Experience in ETL development and data integration.
* Experience with version control systems, such as Git.
* Bachelor's degree in a relevant field or equivalent experience.
Preferred Skills:
* Familiarity with Linux, Terraform, Python, Java, and NoSQL databases is a plus.
* Experience in the healthcare industry is a plus.
Location & Travel:
Remote position for candidates currently residing in the Eastern Time Zone of the United States. Travel to the New York metro area may be required on occasion.
Where required by law, NTT DATA provides a reasonable range of compensation for specific roles. The pay range for this remote role is $91,000 to $141,000. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on several factors, including the candidate's actual work location, relevant experience, technical skills, and other qualifications. This position may also be eligible for incentive compensation based on individual and/or company performance.
This position is eligible for company benefits including medical, dental, and vision insurance with an employer contribution, flexible spending or health savings account, life and AD&D insurance, short- and long-term disability coverage, paid time off, employee assistance, participation in a 401k program with company match, and additional voluntary or legally required benefits.
About NTT DATA Services
NTT DATA Services is a recognized leader in IT and business services, including cloud, data and applications, headquartered in Texas. As part of NTT DATA, a $30 billion trusted global innovator with a combined global reach of over 80 countries, we help clients transform through business and technology consulting, industry and digital solutions, applications development and management, managed edge-to-cloud infrastructure services, BPO, systems integration and global data centers. We are committed to our clients' long-term success. Visit nttdata.com or LinkedIn to learn more.
NTT DATA Services is an equal opportunity employer and considers all applicants without regarding to race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, genetic information, physical or mental disability, veteran or marital status, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. If you need assistance or an accommodation due to a disability, please inform your recruiter so that we may connect you with the appropriate team.
Job Segment: Database, SQL, DBA, Cloud, Developer, Technology
By clicking on "Continue", I give receptix consent to process my data and to send me email alerts, as detailed in receptix's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
Similar jobs
SQL Server DBA - REMOTE
Port Washington, US
08 Mar 2024