Logo
Klanik

Senior Database Developer

Klanik, Norfolk, VA, United States

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

Key Responsibilities:

Database Design & Development:

  • Design normalized databases using PostgreSQL, Oracle, and Snowflake, ensuring data integrity and minimal redundancy.
  • Develop efficient SQL queries, stored procedures, and functions.

Performance Optimization:

  • Analyze and tune slow-running SQL queries and database processes using indexing, query optimization techniques, and performance tuning tools. Experience with tools such as EXPLAIN in PostgreSQL and Oracle.

Database Administration:

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

Cloud Database Management:

  • Manage databases on AWS, leveraging services such as RDS (Relational Database Service) and Snowflake. Migrate on-premises databases to the cloud, addressing challenges such as data volume, network latency, and cost optimization

SQL & Data Warehousing:

  • Work with large datasets in data warehousing environments, specifically using Snowflake.
  • Build and optimize data pipelines for efficient data ingestion and transformation.

Monitoring & Maintenance:

  • Monitor database performance using appropriate tools for PostgreSQL, Oracle, and cloud services.
  • Proactively identify and resolve issues to maintain system performance and reliability.

Collaboration:

  • Work closely with data engineers, analysts, and other stakeholders to ensure database solutions meet business requirements.
  • Provide database support during application development and ensure optimal integration.

Qualifications:

SQL Expertise:

  • Strong proficiency in writing and optimizing complex SQL queries across multiple database systems.

PostgreSQL & Oracle:

  • Hands-on experience with PostgreSQL and Oracle database administration, performance tuning, and optimization.

AWS & Snowflake:

  • Experience with AWS RDS, Snowflake, and cloud database services.
  • Understanding of cloud migration strategies and performance optimization in cloud environments.

Database Administration:

  • Proven experience in backup, recovery, and security management for PostgreSQL and Oracle environments.

Performance Monitoring & Tuning:

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

Preferred Experience:

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