Senior Database Administrator

• Support of production database services to ensure the highest standards of availability, resilience, integrity, security and performance required by our business systems.
• Maintaining multiple Microsoft SQL Server Cluster environments - configuring raw disks, installing Microsoft software, performance tuning in a high availability SAN environment.
• Microsoft SQL Server management - setting up new databases, adding disk space to existing databases and re-building fragmented indexes.
• Install, configure, upgrade software and apply updates to maintain client environments.
• Develop, set up and manage automated backups.
• Set up and manage scheduled database jobs.
• Performance tuning and database optimization.
• Expert problem diagnosis.
• Recommend design alternatives on new and existing relational database models.
• Developing SQL and PL/SQL scripts.
• Setup centralized proactive monitoring, execute scripts, patches, backup reports, status reports and performance monitoring.
• Capacity planning.
• Provision of support and assistance to development team in the design, development, testing, tuning and implementation of database applications.
• Provision of database development and testing environments.
• Assist Quality Assurance, IT and Technical Support staff as required, to resolve both internal and external client issues.
• Ability to work during non-business hours including weekends and holidays, as needed. Some travel may be required.

SKILLS NEEDED

• In-depth knowledge of Microsoft SQL Server 2000, 2005, 2008, 2008R2, 2012, 201, 2019 and higher with production support experience in a multi-project environment.
• In-depth knowledge of SQL and PL/SQL including tuning.
• Migration experience from SQL 2008R2to SQL 2012 or higher.
• SQL performance and tuning skills including server configuration and tracing facilities.
• Good working knowledge of job scheduling and monitoring tools.
• Experience working with multiple projects/tasks and the ability to prioritize quickly and without hesitation.
• Managing and supporting SQL cluster environments.
• Administer, monitor, and maintain MS SQL Server and PostgreSQL database environments (on-premises and/or cloud).
• Design and implement high-availability, replication, backup, and disaster recovery strategies.
• Perform database performance tuning, query optimization, and index management.
• Develop and manage stored procedures, triggers, functions, and other database objects.
• Ensure data security, compliance, and proper access controls across environments.
• Automate routine tasks and database deployments using PowerShell, T-SQL, pgAdmin, or equivalent tools.
• Support database lifecycle management across development, staging, and production environments.
• Experience with supporting multiple teams within a business.
• Strong sense of customer commitment, loyalty, and urgency.
• SharePoint Administration a plus.
• Excellent documentation skills.
• Strong organizational skills.
• Ability to work independently with little supervision.
• Ability to communicate effectively with employees at all levels within the organization.

QUALIFICATIONS NEEDED

• 7+ years of experience in database administration with a strong focus on MS SQL Server (2016 and above).
• 3+ years of hands-on experience with PostgreSQL administration in enterprise environments.
• Strong knowledge of T-SQL, PL/pgSQL, and relational database concepts.
• Experience with Always On Availability Groups, Log Shipping, Mirroring, and pgBouncer, Streaming Replication, etc.
• Solid understanding of backup/restore strategies, monitoring, and capacity planning.
• Familiarity with cloud platforms (e.g., Azure SQL, AWS RDS, or Google Cloud SQL) is a plus.
• Proficiency in scripting and automation (PowerShell, Bash, or Python).
• Proven experience working in a production Internet facing environment.
• Customer service focused. Must be a team player.