Role:

• The Database Administrator will manage, optimize, and secure our database systems. The role involves extensive experience in SQL Database Administration(including monitoring, backups, and performance tuning) and MongoDB(preferably), along with a solid understanding of performance monitoring and optimization techniques for databases.
• The Database Administrator will ensure the reliability, integrity, and availability of database systems, implement efficient backup and recovery strategies, and monitor performance to ensure smooth operations across various platforms.

Challenges:

• Data Growth: Managing and storing increasing amounts of data.
• Data Security: Protecting sensitive customer and financial information from cyber threats.
• Performance Optimization: Ensuring databases can handle heavy work loads and provide fast response times.
• Regulatory Compliance: Adhering to industry regulations and data privacy standards.

Responsibilities

SQL Database Administration:

• Database Monitoring: Oversee the health and performance of SQL databases, ensuring availability, reliability, and scalability.
• Backup and Recovery: Implement and manage comprehensive backup and recovery plans for SQL databases, ensuring data protection and disaster recovery capabilities.
• Database Configuration: Install, configure, and maintain SQL Server instances, databases, and related components.
• Security Management: Administer database security policies, manage user access, and ensure compliance with best practices.
• Troubleshooting and Optimization: Identify and resolve performance bottlenecks in SQL queries, indexing, and server performance. Optimize database configurations for maximum efficiency.
• Patching and Upgrades: Perform regular database software updates and patches to keep systems up to date and secure.
• Replication and High Availability: Configure and maintain high-availability solutions such as Always On Availability Groups, database replication, and clustering.
• Database Performance Tuning: Continuously monitor and optimize SQL query performance, server load,

Technical - Functional Requirements:

• SQL Databases: SQL Server, T-SQL, SQL Server Management Studio (SSMS), Always On Availability Groups, replication, and clustering
• MongoDB: MongoDB Atlas, replica sets, sharding, MongoDB backup/restore strategies
• Performance Monitoring Tools: SQL Profiler, SolarWinds Database Performance Analyzer, MongoDB Monitoring Service (MMS), Nagios, Zabbix, or similar
• Backup Tools: SQL Server Backup, MongoDB Backup, Veeam, or other database-specific backup tools
• Scripting and Automation: PowerShell, Bash, or similar scripting languages for automation of database tasks
• Operating Systems: Windows Server (for SQL Server), Linux (for MongoDB, if applicable)

Education and Certifications:

• Education: Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience
• Certifications (preferred): Microsoft Certified: Azure Database Administrator Associate or similar SQL certification

Experiences Required:

• Minimum of 4 years of experience in database administration, with a strong focus on SQL Server.
• Experience with MongoDB is highly preferred.
• Proven experience in database performance tuning, monitoring, and optimization.
• Solid understanding of backup and recovery processes, as well as high availability and disaster recovery strategies.
• Hands-on experience with SQL Server Management Studio (SSMS), or similar tools.