Database Architect

Summary/Objective:

The Senior Database Architect is responsible for the design, development, implementation, and maintenance of database solutions, with a focus on Microsoft SQL Server and database architecture best practices. This role requires expertise in database design, MS Access database conversions to SQL Server, and a deep understanding of data management principles. The Senior Database Architect will ensure data integrity, availability, and security while supporting the organization's data needs.

Responsibilities:

• Design, develop, and implement MS SQL Server databases, ensuring optimal performance and scalability
• Plan and execute the migration of existing MS Access databases to MS SQL Server, including data mapping, schema design, and Extract, Transform, Load (ETL) processes.
• Develop database architecture strategies for system implementations, ensuring integration and data consistency.
• Conduct database performance tuning, optimization, and capacity planning.
• Establish and enforce database standards, policies, and procedures.
• Develop and maintain data models, database schemas, and data dictionaries.
• Implement and manage database security measures, including user access control and data encryption.
• Perform database administration tasks, including backups, recovery, and maintenance.
• Troubleshoot database issues and provide technical support to development teams.
• Evaluate and recommend new database technologies and tools.
• Collaborate with cross-functional teams to define data requirements and support business objectives.
• Assist with website and application migrations as they relate to database systems.
• Manage user access and develop APIs for data access.

Equipment/Systems :

This position requires frequent use of computers, database management tools, MS SQL Server, MS Access, data modeling tools, and other related software. Experience with Microsoft 365 Suite is essential.

Competencies: The Senior Database Architect role requires meticulous attention to detail, accuracy, and a strong understanding of database design, development, and security best practices. Strong analytical and problem-solving skills are essential, as is the ability to work independently and as part of a team.

• Technical proficiency in MS SQL Server, database design, and data modeling.
• Strong understanding of database architecture principles.
• Experience with MS Access database conversions to SQL Server.
• Knowledge of ETL processes and tools.
• Proficiency in database performance tuning and optimization.
• Knowledge of database security best practices.

Work Environment & Physical Demands:

This job operates primarily in an office setting.This role routinely uses standard office equipment such as computers, phones, and printers.

Position Type and Expected Hours of Work:

This is a full-time exempt position; typical work hours and days are Monday through Friday, regular business hours; additional hours as needed to ensure performance across the program.

Travel: Minimal local travel may be required for training or office visits.

Required Education and Experience:

Requirements

Required Education and Experience:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 10+ years of experience as a Database Developer or Architect with a focus on Microsoft SQL Server.
• Experience with MS Access database conversions to SQL Server.
• Experience with database design, data modeling, and ETL processes.
• Knowledge of database security best practices and secure implementation standards.
• Security+ or equivalent DoD 8140 certification preferred.

Preferred Education and Experience:

• Microsoft certifications related to SQL Server.
• Experience supporting government customers.
• Experience with multiple database platforms preferred (e.g., Oracle, MySQL).
• Experience with data warehousing and business intelligence solutions.

Work Authorization/Security Clearance:

• Requires active Secret clearance from the U.S. Government

Benefits

Benefits Include:

• Covers 100% of employee benefit premiums, including Medical (PPO or HDHP Option), Vision, Dental
• Matching 401K
• Short- and Long-Term Disability
• Pet Insurance
• Professional Development/Education Reimbursement
• Parking and Transit Benefits for NY, NJ, ATL, and DC Metro areas

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.

Qualification

Bachelor's Degree