We are recruiting for a senior-level DBA with expertise in performance tuning, PowerShell scripting, and replication for our client, a rapidly expanding fintech company at the forefront of financial innovations. This role is pivotal in overseeing both production and development database administration, Change Management, and Data Governance across our data repositories, platforms, and tools. Collaborating closely with the database administration, development, and infrastructure teams, you will contribute to the design, implementation, and maintenance of robust data solutions, ensuring adherence to enterprise data management standards and best practices, this position requires a minimum of 5 years of hands-on experience with Microsoft SQL Server 2016/2017/2019/2022.

Key Responsibilities:

• Conduct hands-on technical DBA tasks including requirements gathering, data/database/ETL architecture analysis/design.
• Install, configure, upgrade, and administer database platforms, primarily MS SQL Server.
• Establish and maintain regular maintenance routines for backup, recovery, optimization plans, data archive processes, and data retention plans.
• Proactively monitor and fine-tune database performance, identifying and resolving bottlenecks across network, storage, and database levels.
• Collaborate with developers to optimize database objects and queries for performance and scalability.
• Provide support across all database environments (Production/Staging/UAT/QA/Development) and transaction processes.
• Enforce change control policies and manage database lifecycle processes.
• Monitor and report daily metrics related to database uptime, utilization, and performance indicators.
• Communicate effectively with developers, QA, and management to address complex business problems.
• Expand expertise to manage AWS database environments.
• Conduct peer reviews of database/SQL changes as part of the change management process.
• Develop SSRS reports, standardized SQL reports, and ad-hoc reports as required.
• Create and manage SSAS OLAP cubes.
• Restore databases for development and QA purposes.
• Implement database security standards and best practices.

Qualifications:

• 5-6 years of experience in MS-SQL Server Database Administration.
• Strong troubleshooting skills and ability to resolve database problems.
• In-depth understanding of technical database and development impacts on infrastructure.
• Experience in Performance Tuning and Optimization (PTO) using native and third-party tools.
• Proficiency in SSAS, OLAP cubes, data warehouses, and MDX queries.
• Expertise with SSIS packages, ETL implementation, and troubleshooting.
• Familiarity with SSRS technology and report design.
• Experience with backups, restores, and recovery models.
• Proficiency in Snapshot & Transactional Replication.
• Hands-on experience in operational automation using PowerShell Scripts.
• Familiarity with AWS and database encryption technologies preferred.
• Knowledge of SnowFlake is a plus.
• Strong grasp of indexes, index management, and statistics.
• Understanding of database architecture, physical infrastructure, and storage systems.
• Excellent communication and documentation skills.
• BS or BA in a business or computer science related field.

If you thrive in a dynamic environment where innovation and growth are constant, and you possess the skills and experience outlined above, we encourage you to apply for this exciting opportunity.