SQL Server DBA IRC

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

• 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 Column store 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.

• Managing database storage (mdf/ldf/tempdb allocation), performance tuning (indexing, defragmentation, execution plans, T‑SQL optimization), and SQL Server‑specific features (Column store 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).

• 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.
• Empowering Growth
  :
  We foster a culture of continuous learning and professional development, ensuring timely and comprehensive assistance for every consultant.
• DE&I Matters
  :
  We deeply value and embrace diversity, providing equal opportunities for all individuals in an inclusive work environment.
• Career Development
  :
  Our corporate culture places a strong emphasis on career development, offering abundant opportunities for growth and regular interactions to ensure engagement and recognition.
• Comprehensive Benefits
  :
  In addition to equitable compensation, we provide a benefits package that prioritizes overall well‑being and health.
• Flexible Opportunities
  :
  We prioritize work‑life balance by offering flexible opportunities, including relocation and rotation options for diverse cultural and professional experiences.