Senior Database Developer

Intelligence And National Security Alliance - Norfolk, VA

Full-time

Norfolk, VA

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

We are seeking an experienced Database Developer with expertise in SQL, PostgreSQL, Oracle, and cloud-based database platforms such as AWS and Snowflake. The role involves designing, optimizing, and maintaining complex database systems to support business operations, ensuring high performance, data integrity, and scalability.

Responsibilities

• Design normalized databases using PostgreSQL, Oracle, and Snowflake, ensuring data integrity and minimal redundancy.
• Develop efficient SQL queries, stored procedures, and functions.
• Analyze and tune slow-running SQL queries and database processes using indexing and query optimization techniques.
• Administrate PostgreSQL and Oracle databases, including setting up backup, recovery, disaster recovery, and high availability solutions.
• Ensure security best practices are followed, including user management and access control.
• Manage databases on AWS, leveraging services such as RDS and Snowflake.
• Migrate on-premises databases to the cloud, addressing challenges such as data volume, network latency, and cost optimization.
• Work with large datasets in data warehousing environments, specifically using Snowflake.
• Build and optimize data pipelines for efficient data ingestion and transformation.
• Monitor database performance using appropriate tools for PostgreSQL, Oracle, and cloud services.
• Proactively identify and resolve issues to maintain system performance and reliability.
• Collaborate with data engineers, analysts, and other stakeholders to ensure database solutions meet business requirements.

Requirements

• Strong proficiency in writing and optimizing complex SQL queries across multiple database systems.
• Hands-on experience with PostgreSQL and Oracle database administration, performance tuning, and optimization.
• Experience with AWS RDS, Snowflake, and cloud database services.
• Proven experience in backup, recovery, and security management for PostgreSQL and Oracle environments.
• Experience with database performance monitoring and tuning tools such as PostgreSQL EXPLAIN, Oracle AWR, and AWS CloudWatch.
• Strong analytical and problem-solving skills, with attention to detail.

Nice-to-haves

• Experience in data warehousing with Snowflake.
• Experience with large-scale cloud database migrations.
• Knowledge of AWS infrastructure and services related to databases (e.g., S3, Lambda, Redshift).