SQL Administrator

Job Summary:

The SQL Administrator is responsible for installing, configuring, upgrading, administering, monitoring, and maintaining databases in an organization. They ensure that the databases are secure, backed up, and able to handle the needs of the business. The SQL Administrator also works on performance tuning, data integrity, and provides technical support for database-related tasks.

Key Responsibilities:

1. Database Management:
   • Install, configure, and upgrade SQL databases (e.g., SQL Server, MySQL, Oracle).
   • Maintain database systems by implementing and enforcing database policies and procedures.
   • Plan and execute database backups, recovery, and archiving processes.
2. Performance Tuning and Optimization:
   • Monitor database performance, troubleshoot issues, and perform tuning.
   • Optimize queries, indexes, and other database elements to ensure fast and efficient data retrieval.
3. Security Management:
   • Implement and maintain database security, including roles, permissions, and encryption.
   • Conduct regular security audits and ensure compliance with security standards.
4. Data Integrity and Backup:
   • Ensure the integrity and availability of data through automated backups, replication, and failover procedures.
   • Monitor and resolve data corruption issues.
5. Technical Support and Troubleshooting:
   • Provide technical support for developers, analysts, and end-users on database-related issues.
   • Troubleshoot and resolve database-related problems.
6. Database Development:
   • Assist in designing, developing, and deploying new databases and database-driven applications.
   • Collaborate with developers to ensure efficient database designs.
7. Documentation and Reporting:
   • Maintain accurate documentation of database configurations, processes, and procedures.
   • Generate and maintain reports on database performance, security, and utilization.
   • Knowledge of Microsoft Reporting systems, is a plus.
8. Disaster Recovery Planning:
   • Develop and implement disaster recovery plans for databases.
   • Regularly test and update disaster recovery plans.

Qualifications:

• Education: Bachelor’s degree in computer science, Information Technology, or a related field.
• Experience: 3 years of experience as a SQL Administrator or DBA.
• Certifications: Relevant certifications such as Microsoft Certified: Azure Database Administrator, Oracle Database Administrator Certified Professional, etc.
• Technical Skills:
  • Proficiency in SQL, T-SQL, PL/SQL, and other database programming languages.
  • Experience with database management tools and platforms (e.g., SQL Server Management Studio, Oracle DBMS, MySQL Workbench).
  • Knowledge of database backup and recovery processes, high availability, and disaster recovery options.
  • Familiarity with operating systems (Windows, Linux) and scripting languages (PowerShell, Bash).
• Soft Skills:
  • Strong problem-solving and analytical skills.
  • Good communication and collaboration skills.
  • Attention to detail and the ability to work independently.

Preferred Qualifications:

• Experience with cloud-based databases (e.g., Azure SQL, AWS RDS).
• Familiarity with data warehousing, ETL processes, and BI tools.
• Experience with database monitoring tools (e.g., SolarWinds, Nagios).

Work Environment:

• This role typically involves working in an office environment or remotely, depending on the company’s policy.
• May require after-hours work for maintenance, upgrades, or emergencies.