Sr Database Architect

Job Description

Job Description

Description:

Senior Database Architect (Data Specialist / Engineer – Master)

Job Summary

B&A is seeking a highly experienced Senior Database Architect (Data Specialist / Engineer – Master) to lead the design, development, and optimization of enterprise database solutions. This role requires deep expertise in Microsoft SQL Server, large-scale data migration, and ETL processes. The ideal candidate will be responsible for architecting and implementing robust, scalable database schemas and supporting data integration activities in support of enterprise content management systems, such as OpenText.

Responsibilities

• Architect, design, and manage SQL Server database solutions to support enterprise applications and data services.
• Lead the implementation of database schemas, stored procedures, indexing strategies, and performance optimization plans.
• Perform large-scale data migration and integration activities using industry best practices and proven ETL techniques.
• Ensure data integrity, consistency, security, and availability across platforms.
• Collaborate with solution architects, application developers, and business analysts to align database architecture with application requirements.
• Analyze and troubleshoot complex database performance and scalability issues.
• Support database lifecycle management including backup and recovery strategies, high availability, and disaster recovery planning.
• Document database architectures, processes, data flows, and related technical specifications.

Education and Experience

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related discipline, or equivalent work experience.
• 10+ years of hands-on experience in database administration and architecture with Microsoft SQL Server .

Required Skills

• Extensive experience in large-scale data migration , including extract, transform, and load (ETL) operations.
• Proven track record of implementing robust database schemas and managing schema evolution in enterprise environments.
• Strong SQL programming skills including T-SQL development, performance tuning, and query optimization.

Desired Skills

• Experience integrating or supporting OpenText ECM platforms such as Content Suite, AppWorks, or Archive Center.
• Familiarity with data modeling tools (e.g., ER/Studio, ERwin, Microsoft Visio).
• Experience with data warehousing, business intelligence platforms, or analytics tools.
• Working knowledge of data governance, data quality, and metadata management best practices.
• Exposure to secure environments (e.g., HIPAA, DoD, or FedRAMP-compliant systems).
• Certifications in SQL Server, data architecture, or ETL tools are a plus (e.g., Microsoft Certified: Azure Data Engineer, MCSA: SQL Database Development).
• Excellent problem-solving and analytical abilities.
• Strong communication and collaboration skills across technical and non-technical teams.
• Self-motivated, proactive, and able to work independently or as part of a team.
• Exceptional attention to detail with strong documentation and organizational skills

Security Clearance

• Eligible to obtain a Public Trust Clearance.

More About B&A:

Notable Clients
B&A has grown to be a company that is trusted by our clients for exceptional service, innovative solutions, and inspired employees. Our service extends through federal, state, and local Government, the private sector, and higher education. Some of our notable clients include Department of Homeland Security, U.S. Customs and Border Protection, U.S. Senate, U.S. Courts, U.S. Census Bureau, U.S. Navy, and more.

Benefits and Programs

B&A is proud to offer three robust individual and family medical plans to full time employees, including a Health Savings Account (HSA) option as well as two tiers of dental coverage, vision, life & AD&D, disability, accident, hospital indemnity, and critical illness insurance. In addition to these benefits, B&A employees enjoy paid time off, B&A sponsored trainings and certifications, pet insurance benefits, commuter transit benefits and a free subscription to a virtual exercise platform (NEOU). B&A’s 401(k) plan is available to all employees and includes a company matching contribution.

B&A has launched several programs to focus on employee engagement, wellness, and assistance. These include:

• The B&A Cares program: 30/60/90-day wellness check ins, personal development, financial management, and stress management seminars, and more
• A formal mentorship program
• Job shadowing and cross training opportunities
• Brand Ambassador program
• Employee Assistance Program (EAP) - Access to various support resources to include counseling, legal guidance, financial planning, and more
• Monthly teambuilding events
• B&A Annual Wellness Challenges: #StepWithB&A, #WalkDuringLunchWithB &A, #VolunteeringWithB&A, #ExerciseDuringLunchWithB &A, and more

At B&A, we place significant importance on improving the communities and lives of citizens across the nation through our involvement, technology expertise, and employees. B&A puts an emphasis on charitable efforts in the Northern Virginia area, including Capital Area Food Bank pantry drives, book donations, Hope for Henry Foundation events, and many more. In recognition of all these efforts, B&A has been named a Companies as Responsive Employers (CARE) award recipient by Northern Virginia Family Services and nominated by the Northern Virginia Chamber of Commerce for Outstanding Corporate Citizenship Award.

EEO

B&A provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. B&A complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy covers conduct occurring at B&A’s offices, and other workplaces (including client sites) and all other locations where B&A is providing services, and to all work-related activities.

EEO is the Law

B&A participates in e-Verify. We provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) with information from each new employee’s I-9 Form to confirm work authorization.