SQL Developer

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., * 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., Must haves: The DBA/SD will be responsible for performing the tasks listed in Table 6.4 and possess the knowledge and skills shown in Table 6.5. Programming Knowledge and Softwar…
• 1 month ago +

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