Senior Database Architect

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.