SQL Developer

Akaasa Technologies; Woodbridge (VA); Hybrid; USD 85,000 - 120,000; Full time

Job summary

Akaasa Technologies in Woodbridge, VA is seeking a SQL Developer with strong experience in database management, complex SQL querying, and data analysis. The role focuses on Oracle, SQL Developer tools, Python, and PostgreSQL/PSQL to design and optimize databases.

Hybrid work arrangement with three days onsite per week. You will develop, maintain, and optimize queries, support the database lifecycle, and collaborate with cross-functional teams on GIS/ArcGIS related tasks when needed.

Qualifications

• Strong SQL skills with hands-on Oracle experience and SQL Developer/TOAD/SQLPlus.
• Experience with Python and PostgreSQL/PSQL for data analysis and reporting.
• Ability to design, build, and optimize relational databases with a focus on performance.
• GIS/ArcGIS and Cityworks experience is a plus for utility environments.
• Experience with version control tools such as GitHub.

Responsibilities

• Develop, maintain, and optimize complex SQL queries, procedures, and scripts.
• Design, build, and manage relational databases, preferably Oracle.
• Perform data analysis, reporting, and create tabular and spatial reports.
• Ensure data quality, integrity, and performance optimization.
• Support the database development lifecycle and troubleshooting.
• Collaborate with cross-functional teams across projects.

Skills

SQL

SQL Developer

TOAD

SQLPlus

Oracle

Python

PostgreSQL

Database design

Query optimization

Data analysis

Troubleshooting

GitHub

Tools

GitHub

Job description

SQL Developer Woodbridge, VA (Hybrid)

Woodbridge, VA. Hybrid 3 days onsite per week

Seeking a SQL Developer with strong experience in database management, complex SQL querying, database design, optimization, and data analysis. Experience with Oracle, SQL Developer/TOAD/SQLPlus, Python, and PostgreSQL/PSQL is required. GIS/ArcGIS and Cityworks experience is a nice-to-have, particularly in utility sector.

Job Description

We are seeking a skilled SQL Developer with strong experience in database management, complex SQL querying, database design, optimization, and data analysis. The ideal candidate will have hands-on experience with Oracle, SQL Developer, TOAD, SQLPlus, Python, and PostgreSQL/PSQL.

Experience with GIS/ArcGIS and Cityworks is a nice-to-have, particularly in utility or water/wastewater environments.

Key Responsibilities

• Develop, maintain, and optimize complex SQL queries, procedures, and scripts.
• Design, build, and manage relational databases, preferably Oracle.
• Perform data analysis, reporting, and create tabular and spatial reports.
• Ensure data quality, integrity, and performance optimization.
• Support the database development lifecycle and troubleshooting.
• Collaborate with cross-functional teams across projects.

Required Skills

• Strong SQL skills and experience.
• Experience with SQL Developer, TOAD, and SQLPlus.
• Oracle database experience.
• Python and PSQL/PostgreSQL.
• Database design and optimization.
• Complex data analysis and reporting.
• Troubleshooting and performance tuning.
• Experience with version control tools, such as GitHub.
• Strong analytical and problem-solving skills.

Nice to Have GIS / ArcGIS

• ArcGIS Pro and ArcGIS Server.
• Trimble Cityworks.
• Geodatabase and SDE versioning.
• Publishing services and sharing content to ArcGIS Online/Portal.
• GIS data analysis and validation.
• Experience in water/wastewater utility environments.