SQL Database Administrator - PowerShell (8-9 yrs)

Job Summary:

The SQL Database Administrator will manage and maintain all aspects of our SQL Server environment, including installation, configuration, performance tuning, backup and recovery, security, and troubleshooting.

This role requires a deep understanding of SQL Server architecture, best practices, and a proactive approach to problem-solving.

Responsibilities :

Installation and Configuration: Install, configure, and upgrade SQL Server instances and related components.

Database Administration: Create, configure, and manage databases, tables, indexes, stored procedures, triggers, and other database objects.

Performance Tuning: Monitor database performance, identify bottlenecks, and implement optimizations to ensure optimal performance and scalability.

This includes query optimization, index tuning, and server configuration adjustments.

Backup and Recovery: Develop and implement robust backup and recovery strategies to ensure business continuity and data availability in case of system failures or disasters.

- Regularly test backups and recovery procedures.

Security Management: Implement and maintain database security measures, including user access control, permissions management, and auditing.

- Ensure compliance with security policies and regulations.

Troubleshooting: Diagnose and resolve database-related issues, including performance problems, connectivity issues, and data corruption.

- Provide timely support to application developers and end-users.

Monitoring: Proactively monitor database health and performance using monitoring tools and alerts.

- Identify potential issues and take corrective actions before they impact users.

Documentation: Maintain accurate and up-to-date documentation of database configurations, procedures, and security settings.

Automation: Automate routine database administration tasks using scripting languages (e.g , PowerShell, T-SQL) to improve efficiency and reduce manual errors.

Collaboration: Work closely with application developers, system administrators, and other IT staff to ensure seamless integration of database systems with other infrastructure components.

Capacity Planning: Participate in capacity planning activities to ensure that the database environment can meet future growth demands.

Staying Current: Keep up-to-date with the latest SQL Server features, patches, and best practices.

Qualifications :

- Bachelor's degree in Computer Science or a related field preferred.

- Proven experience as a SQL Database Administrator (minimum [Number] years).

- Strong understanding of SQL Server architecture, internals, and best practices.

- Expertise in T-SQL programming and query optimization.

- Experience with database performance tuning and troubleshooting.

- Solid understanding of backup and recovery strategies.

- Knowledge of database security principles and practices.

- Experience with database monitoring tools and techniques.

- Familiarity with scripting languages (e.g , PowerShell, T-SQL).

- Excellent communication and collaboration skills.

- Ability to work independently and as part of a team.

- Strong problem-solving and analytical skills.

- Experience with [Cloud platforms like Azure or AWS] is a plus.

Relevant certifications, such as MCSA: SQL Server or MCSE: Data Platform are a plus