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.
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.