ITC Infotech
Website:
itcinfotech.com
Job details:
Senior SQL DBA (10+ Years Experience): Please apply only if your Notice period is below 30 days
Job Qualifications:
- 10+ Years of experience with Computer Science or equivalent degree Preferred
- Strong knowledge of database management, data warehouse management and decision support tools
- Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
- Ability to use database access tools for application delivery
- Demonstrated ability to work independently and with others
- On-call and 24x7 Support
Job Responsibilities:
- Assesses future information requirements in order to develop long-range, comprehensive database plans
- Develops policies and procedures designed to ensure the integrity of the database environment
- Develops and maintains routines to facilitate database use
- Keeps informed on latest developments in the database management field
- Plans and coordinates migration to new data management system software levels
- Assures that appropriate database management software is available and effectively used
- Understands benchmarking processes and techniques
- Determines, implements, and enhances standards on database security
- Promotes and recommends appropriate database software for new application systems
- Educates applications programmers about database concepts and efficient access techniques, and assists them in analysis and problem resolutions pertaining to database
- Performs database performance monitoring and implements efficiency improvements
- Designs or supervises the designing of the procedures necessary to save and recover databases from hardware and software failures
- Supervises the design and maintenance of database structures
- Performs related work as assigned
Technical Knowledge:
- Install, configure, upgrade, and maintain Microsoft SQL Server (2012/2016/2019/2022).
- Manage and support hybrid database environments across on-premises data centers and cloud platforms (Azure / AWS).
- Manage production, staging, and development environments.
- Perform regular database maintenance activities including index rebuilds, statistics updates, and integrity checks.
- Monitor database systems to ensure high performance, availability, and security.
- Manage database objects such as tables, indexes, views, stored procedures, and triggers.
- Design, implement, and manage:
- AlwaysOn Availability Groups (AG)
- SQL Server Failover Cluster Instances (FCI)
- Log Shipping and Replication
- Perform failover, failback, and DR drills to validate business continuity.
- Ensure minimal downtime and data loss through optimized HA/DR strategies.
- Troubleshoot issues related to cluster, quorum, and availability replicas.
- Analyze and optimize slow-running queries, stored procedures, and execution plans.
- Implement indexing strategies and optimize locking, blocking, and deadlocks.
- Tune server-level settings (memory, CPU, tempdb configuration).
- Diagnose and resolve database performance issues, outages, and failures.
- Perform root cause analysis (RCA) for incidents.
- Address issues such as: Blocking / deadlocks, High CPU, memory pressure, Disk I/O bottlenecks
- Design and implement robust backup and recovery strategies.
- Perform point-in-time recovery and restore operations.
- Ensure backup validation and compliance with RPO/RTO requirements.
- Manage database security: Logins, roles, permissions, Encryption (TDE - Transparent Data Encryption)
- Implement auditing and compliance requirements.
- Apply security patches and updates regularly.
- Work closely with developers to:
- Optimize SQL queries and database schema design
- Review code for performance and scalability
- Support deployments and release activities
- Provide guidance on Best practices for SQL coding, Indexing and performance optimization
- Assist in performance testing and capacity planning.
- Develop scripts using PowerShell, Python, or SQL for automation and monitoring.
- Automate routine DBA tasks such as backups, health checks, and alerting.
- Experience with tools like OEM (Oracle Enterprise Manager) or similar monitoring tools.
- Work within SLA timelines in a 24x7 support environment.
Click on Apply to know more.