SQL Server DBA IRC297234

Description

Client is a company based in the US, providing solutions and common infrastructure to enable telecommunications partners to deploy and expand next-generation technologies

Requirements

Storage Management & Performance Tuning: Optimizing disk space allocation (mdf, ldf, and tempdb files), maintaining indexes (defragmentation, rebuilding), analyzing execution plans, and optimizing T-SQL queries.SQL Server-Specific

Features: Leveraging advanced built-in technologies such as Columnstore Indexes for analytics and data compression, and In-Memory OLTP for high-throughput transaction processing.Data Security: Enforcing user access control via logins, database users, and roles, managing schemas, and securing sensitive data using Transparent Data Encryption (TDE) and Always Encrypted.

Maintenance & High Availability: Handling backup and restore strategies (Full, Differential, Transaction Log), ensuring data integrity (DBCC CHECKDB), performing patching, and implementing high availability/disaster recovery (HA/DR) via Always On Availability Groups, Failover Cluster Instances (FCI), or Log Shipping.

Job responsibilities

Managing database storage (mdf/ldf/tempdb allocation), performance tuning (indexing, defragmentation, execution plans, T-SQL optimization), and SQL Server-specific features (Columnstore Indexes, In-Memory OLTP).

Ensuring data security, user access control via Logins, Users, and Roles at the schema level, and data encryption (Transparent Data Encryption – TDE, Always Encrypted).

Handling backup and recovery strategies (Full, Differential, Transaction Log), patching, database integrity checks (DBCC CHECKDB), and high availability/disaster recovery (Always On Availability Groups, Failover Cluster Instances).

What we offer

Empowering Projects: With 500+ clients spanning diverse industries and domains, we provide an exciting opportunity to contribute to groundbreaking projects that leverage cutting-edge technologies. As a team, we engineer digital products that positively impact people’s lives.

Empowering Growth: We foster a culture of continuous learning and professional development. Our dedication is to provide timely and comprehensive assistance for every consultant through our dedicated Learning & Development team, ensuring their continuous growth and success.

DE&I Matters: At GlobalLogic, we deeply value and embrace diversity. We are dedicated to providing equal opportunities for all individuals, fostering an inclusive and empowering work environment.

Career Development: Our corporate culture places a strong emphasis on career development, offering abundant opportunities for growth. Regular interactions with our teams ensure their engagement, motivation, and recognition. We empower our team members to pursue their career goals with confidence and enthusiasm.

Comprehensive Benefits: In addition to equitable compensation, we provide a comprehensive benefits package that prioritizes the overall well-being of our consultants. We genuinely care about their health and strive to create a positive work environment.

Flexible Opportunities: At GlobalLogic, we prioritize work-life balance by offering flexible opportunities tailored to your lifestyle. Explore relocation and rotation options for diverse cultural and professional experiences in different countries with our company.

About GlobalLogic

GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.