Simform Solutions - Database Administrator - SQL Server

Responsibilities
• Administer, configure, and maintain Microsoft SQL Server (on-premises) and AWS RDS/Redshift environments.
• Perform regular maintenance tasks such as backups, restores, patching, and capacity planning.
• Manage database security, user access, and roles across environments.
• Provision, configure, and manage AWS RDS (SQL Server, PostgreSQL) and Redshift instances.
• Implement backup strategies, monitoring, and disaster recovery solutions in the cloud.
• Automate routine database tasks and processes using AWS tools and scripting.
• Deploy and monitor AWS Glue and AWS Lambda.
• Troubleshoot ETL job failures, ensure data quality, and support timely delivery of data.
• Use tools like AWS CloudWatch, SolarWinds, and Redgate SQL Monitor for real-time performance tracking and alerting.
• Identify and resolve performance bottlenecks in SQL queries, indexes, and server configurations.
• Act as a point of contact for database-related incidents and outages.
• Perform root cause analysis, document findings, and work with engineering teams to implement long-term fixes.
• Maintain comprehensive and up-to-date documentation on database systems, configurations, and procedures.
• Collaborate with development and DevOps teams to support database and data platform needs.
• Contribute to automation and infrastructure improvements in cloud and hybrid environments.
• Maintain detailed documentation and knowledge base articles for internal :
• Experience as a database administrator, with a strong foundation in SQL Server administration, backup/restore strategies, and

high availability solutions (e.g., Always On, clustering).
• Hands-on experience managing AWS RDS (SQL Server/PostgreSQL) and Amazon Redshift, including provisioning, scaling, backups,

snapshots, and security configurations.
• Proficiency with monitoring tools like AWS CloudWatch, SolarWinds, and Redgate SQL Monitor, with the ability to configure alerts,

identify trends, and proactively address performance bottlenecks.
• Expertise in performance tuning for :
• SQL Server : Execution plan analysis, indexing strategies, TempDB optimization, query tuning.
• RDS : Parameter group tuning, performance insights, instance sizing.
• Redshift : WLM configuration, vacuum/analyze, distribution/sort keys, and query optimization.
• Strong understanding of database security best practices, user access controls, encryption, and auditing.
• Experience managing incident response, including root cause analysis, mitigation planning, and follow-up documentation.
• Ability to create and maintain detailed runbooks, SOPs, and knowledge base articles for repeatable processes and troubleshooting procedures.
• Comfortable working in hybrid environments, with coordination across on-premises and cloud-based systems.
• Familiarity with automation and scripting using PowerShell, Python, or Bash to streamline database tasks and monitoring.
• Hands-on experience with CI/CD pipelines to support database changes and deployments using tools like AWS CodePipeline or GitLab CI.
• Experience integrating database deployments into DevOps pipelines, including version-controlled DDL/DML scripts, pre-deployment checks, and rollback strategies.
• Ability to perform manual deployments when required (e.g., via SSMS, pgAdmin, or SQL scripts) while adhering to change management processes.
• Ability to work independently, manage priorities, and take ownership of tasks in a distributed team environment.
• Strong communication and interpersonal skills, with the ability to explain technical concepts clearly to both technical and non-technical stakeholders.
• A proactive and detail-oriented mindset, with a focus on continuous improvement and system reliability.

(ref:hirist.tech) Read more