Logo
TechnoGen

Senior Database Architect

TechnoGen, Washington, District of Columbia, us, 20022


Senior Database Architect

Remote- EST time zone preferred candidates

Contract: 6-12+ months

Pay Rate: Market/Negotiable

We are seeking a highly skilled

Senior Database Architect

to lead our database optimization and migration efforts. We're looking for someone who can refine our complex data model, optimize stored procedures, and spearhead our

migration from SQL Server to PostgreSQL.

Responsibilities:Analyze and refine our 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.Preferred Qualifications:

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.