Senior Database Architect

Technogen - Washington, DC

Full-time - Senior

Washington, DC

1-10 employees

Professional, Scientific, and Technical Services

About the position

The Senior Database Architect at TECHNOGEN, Inc. is responsible for leading database optimization and migration efforts, specifically transitioning from SQL Server to PostgreSQL. This role requires a deep understanding of complex data models and the ability to enhance database performance and scalability. The architect will collaborate with software development teams, implement security measures, and mentor junior developers, ensuring the integrity and efficiency of database systems.

Responsibilities

• Analyze and refine existing complex data model to improve performance and scalability.
• Review, optimize, and refactor existing stored procedures for better efficiency.
• Lead the migration effort from SQL Server to PostgreSQL, ensuring data integrity and minimal disruption.
• Evaluate and recommend which stored procedures should be converted to middle-tier logic.
• Design and implement database schemas that represent and support business processes.
• Develop database architectural strategies that address availability, performance, security, and scalability requirements.
• Collaborate with software development teams to integrate database systems with applications.
• Implement and maintain database security measures.
• Develop and maintain documentation of database architecture and procedures.
• Mentor junior database developers and provide technical leadership.

Requirements

• Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree preferred.
• 8+ years of experience as a database architect or in a similar role.
• Expert-level knowledge of SQL Server, including complex query optimization and stored procedure development.
• Strong experience with PostgreSQL, including migration strategies from other database systems.
• Proven track record of optimizing complex data models and improving database performance.
• Experience in converting database logic to application-tier logic.
• Solid understanding of database security principles and best practices.
• Familiarity with modern application architectures and their interaction with databases.
• Experience with database monitoring and performance tuning tools.
• Strong analytical and problem-solving skills.
• Excellent communication skills, able to explain complex database concepts to both technical and non-technical stakeholders.

Nice-to-haves

• Experience with cloud-based database solutions (e.g., AWS RDS, Azure Database).
• Knowledge of data warehousing concepts and ETL processes.
• Familiarity with NoSQL databases.
• Experience with Agile development methodologies.