Senior RDBMS Architect & Data Solutions Lead

Computer Task; Buffalo (NY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

CTG is seeking a Database Administrator IV to join our team in Buffalo, NY. The role focuses on serving as SME and technical architect for complex RDBMS solutions, aligning designs with business objectives and regulatory requirements.

You will lead database enhancements, performance tuning, and production issue resolution while mentoring junior staff and coordinating with application owners and vendors to drive strategic initiatives.

Qualifications

• Requires associate degree plus 8+ years of RDBMS experience or 10+ years combined education/work.
• Strong SQL skills and relational database design, administration and performance optimization.
• Experience with modern data architecture and cloud data platforms (Azure, Snowflake).

Responsibilities

• Serve as SME and technical architect for complex RDBMS solutions and initiatives.
• Consult with application owners to design scalable, efficient database solutions.
• Lead database enhancements, performance tuning, and production issue resolution.
• Oversee complex projects, manage timelines, and coordinate with teams and vendors.

Skills

RDBMS expertise

SQL proficiency

Analytical thinking

Stakeholder communication

Project coordination

Education

Bachelor's degree or higher

Tools

Azure

Snowflake

SQL Server

Oracle

Job description

Are you ready to join a growing team?

CTG is seeking to fill a Database Administrator IV opening for our client.

Location: Buffalo, NY
Duration: 12 months

Primary Responsibilities:

• Serve as a subject matter expert (SME) and technical architect for complex Relational Database Management System (RDBMS) solutions and enterprise-wide initiatives.
• Consult with application owners to analyze business requirements and recommend scalable, efficient database designs and enhancements.
• Develop database architecture and solutions aligned with business objectives, technology standards, regulatory requirements, and long-term strategic goals.
• Lead complex database enhancements, system conversions, performance tuning, production troubleshooting, and issue resolution.
• Evaluate database technologies, vendor products, and cloud data solutions, recommending improvements to performance, reliability, and operational efficiency.
• Translate business requirements into functional specifications and technical designs; review database changes and support integrated testing.
• Oversee complex project plans, manage task dependencies, mitigate risks, and coordinate with technology teams, application owners, and vendors.
• Provide technical guidance, training, and mentorship to less experienced database professionals.
• Support business continuity, audit readiness, internal controls, and compliance with regulatory requirements and company risk policies.
• Identify opportunities to improve database development, processes, standards, and technology solutions while minimizing risk and cost.

Scope of Responsibilities:

Work under the direction of a Senior Technology Manager, providing expert RDBMS guidance, solution design, and strategic technical recommendations. Contribute to departmental strategy, project execution, production support, and resource planning. Collaborate with technology leadership, architecture teams, application owners, and vendors while supporting staff development and serving as a technical representative on complex initiatives.

Supervisory/Managerial Responsibilities:

Provide technical leadership, mentoring, and training to less experienced staff. Guide database design, development, troubleshooting, performance tuning, and testing efforts. Coordinate technical activities and support project teams without necessarily having direct personnel management responsibilities.

Education and Experience Required:

• Associate degree and at least 8 years of RDBMS experience, or a combined minimum of 10 years of higher education and/or work experience, including at least 8 years of RDBMS experience.
• Strong SQL skills and expertise in relational database design, administration, and performance optimization.
• Experience with modern data architecture, such as Medallion Architecture, and cloud data platforms, such as Microsoft Azure and Snowflake.
• Proven experience leading complex database projects, system enhancements, conversions, and production issue resolution.
• Experience managing multiple complex projects simultaneously, including project planning, task coordination, testing, and risk mitigation.
• Strong analytical, troubleshooting, decision-making, organizational, and time-management skills.
• Excellent written and verbal communication, presentation, and stakeholder management skills.
• Ability to translate complex business and technical requirements into effective database solutions and collaborate across teams.

Education and Experience Preferred:

• Bachelor's degree or higher.
• At least 3 years of experience supporting banking applications, business processes, and database strategy.
• Previous experience in banking RDBMS support and familiarity with banking technology standards, business objectives, and regulatory requirements.
• Advanced knowledge of multiple RDBMS platforms, database tools and functions, and operating systems.
• Proven leadership and mentoring experience in database analysis, architecture, development, troubleshooting, and performance tuning.
• CAPPM experience.
• Strong understanding of business terminology and the technical, operational, and business impacts of technology changes.
• Ability to foster teamwork, influence technical direction, and serve as a trusted advisor to business and technology stakeholders.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

To Apply:

To be considered, please apply directly to this requisition using the link provided. Kindly forward this to any other interested parties. Thank you!

About CTG

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results-driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visitwww.ctg.com.

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.