Track Lead (Support & Operations) (IN)
HCLTech
HCLTech
Seeking a skilled Database Administrator to provide critical production support for PenFed Credit Union's business-critical SQL Server systems. This role involves managing SQL Servers with AlwaysON for high availability, building new servers according to established benchmarks, and serving as a Subject Matter Expert for database projects and automation.
You will actively participate in application database design, server upgrades, and migrations to AWS. Key responsibilities include ensuring database integrity, managing backups and recoveries, and optimizing performance through collaboration with developers and business users.
This position requires developing and maintaining comprehensive documentation, executing security patching, and ensuring the overall stability, security, and efficiency of the database environment. The role also involves interacting with stakeholders to identify and implement improvements, managing SSIS packages, and contributing to disaster recovery planning and validation.
Provide robust production support for SQL Server databases, ensuring high availability with AlwaysON configurations.
Build and configure new SQL Server instances adhering to baseline and security benchmarks.
Act as a Technical Lead and Subject Matter Expert for database projects, implementations, and task automation.
Engage in application database design, server upgrades, and migrations, including to AWS hosting.
Manage database backups, recoveries, and support high availability systems.
Collaborate with developers and business users to optimize database design, index utilization, and query performance.
Develop and maintain essential operational documentation.
Execute security patching and cumulative upgrades for critical applications.
Ensure the stability, integrity, security compliance, and efficiency of the database environment.
Identify and drive areas of improvement through stakeholder interaction.
Maintain and deploy SSIS packages as per business needs.
Contribute to the development and validation of Business Continuity and Disaster Recovery plans.
Adhere to security, incident management, and change management procedures.
Implement TDE and TLS 1.2 for secure SQL Server operations.
Participate in design discussions to align SQL Server designs with organizational standards and roadmaps.
Contribute to version upgrades, SSIS package development, capacity planning, and disaster recovery execution.
Proven experience in providing production support for SQL Server databases, particularly with AlwaysON configurations.
Expertise in building and configuring new SQL Server servers against established benchmarks (BaseLine, Gold Image, CIS).
Strong technical leadership and Subject Matter Expertise in database projects, implementations, and automation.
Experience with application database design, server upgrades, and migration to cloud environments like AWS.
Proficiency in managing database backups, recoveries, and supporting high availability systems.
Skilled in performance tuning, including index utilization and query optimization, working with developers and business users.
Ability to develop and maintain comprehensive operational documentation.
Experience with security patching and cumulative upgrades of business-critical applications.
Knowledge of TDE, TLS 1.2, and secure SQL Server configuration best practices.
Familiarity with SSIS packages, their deployment, and development.
Experience in capacity planning and disaster recovery planning and execution.
Understanding of Security, Incident Management, and Change Management procedures.
Ability to participate in 24x7 on-call support for system outages.
Familiarity with SQL Server version upgrades.
Strong problem-solving and analytical skills.
HCLTech
IT Consulting