SQL Database Administrator - HCLTech
Tysons Corner, VA 22102
About the Job
- Provide Database Administration production support for SQL Server Database business critical systems.
- Production support of SQL Servers with AlwaysON in high Availability configuration.
- New servers build as per BaseLine(Gold Image) and CIS benchmark
- Serve as a
DBA Technical Lead and Subject Matter Expertise
for Database projects, implementations, and tasks automation. - Participate in application database design, new server build, upgrade, and migration to AWS hosting.
- Accountable for maintaining database backups and recoveries, and providing support for high availability systems in AlwaysON configuration.
- Work with developers and business users on improving database design, indexes utilization and queries performance tuning.
- Develop and maintain proper documentation, including configuration specifics, and procedures for ongoing operation/maintenance.
- Accountable for security patching and cumulative upgrades of business-critical applications.
- Responsible for SQL Server Database stability, integrity, security compliance and efficiency of the systems that support core functions of the business.
- Interact with senior engineers, management, vendors and other stakeholders to identify areas of improvement.
- Maintain SSIS packages and perform deployments per business requirements.
- Accountable for ensuring delivery of all assigned projects and tasks, Project implementation
- Participate in development and validation of Enterprise Business Continuity and Disaster Recovery plans.
- Maintain compliance to Security, Incident Management, and Change Management procedures.
- Maintain up-to-date knowledge of the IT industry as it relates to the technologies and processes in Database domain, relevant organizational knowledge, and project management practices.
- Implement TDE, TLS 1.2 and maintain secure configuration and operation of SQL Server systems according to industry best practices.
- Participate in projects design discussions to ensure SQL Server Database designs are aligned with the PenFed Secure By Design philosophy, the PenFed architecture, and also the current roadmap.
- SQL Servers version upgrades to latest version
- SSIS packages development and implementation
- New servers build as per BaseLine(Gold Image) and CIS benchmark
- Capacity planning
- Disaster Recovery planning and execution
- DB Backup/recovery implementation
- Documentation
- Participates in DBA on-call 24X7 support in the event of system outage or failure.
Source : HCLTech