Experience using modern software development life cycle processes within a team setting, including formal source code management and revision control systems
Excellent customer service and communication skills as well as the ability to prioritize and meet deadlines
Skills designing, developing and managing one or more of the following database systems MySQL, PostGRES, Oracle, MSSQL, experience with multiple database systems is preferred.
Experience with Google Maps API, ArcGIS for integration with the application
Establish database management systems standards, guidelines and quality assurance for database deliverable, such as conceptual design, logical data model capacity planning, external data interface specs, data loading, data maintenance plan and security policies
Develop and maintain robust, scalable database code
Create and maintain web based applications using HTML, PHP, ASP.net
Translate business requirements to data and technical specifications
Develop SQL queries for data extraction, analysis and reporting
Understand existing SQL code and make any required modifications
Verify accuracy of data extracted for reporting.
Analyze problem incidents, debug SQL and implement fixes.
Expert level Excel, Visual Basics, SQL, Oracle Databases and MS Access or similar systems a must
Able to design, code, debug and maintain database schemas and stored procedures
Able to team up with software engineers and produce maintainable data interface layers within application
Has knowledge of and conforms to SDLC principles
Experience with data modeling tool UML etc
Design an efficient reporting solution for the specific business requirement.
Understand reporting, know how to use reporting tools, and automate reports and deliverables
Assist in the management of client data in SQL Server SDE environment
Assist in the creation of new directories on IIS web servers
Other duties as assigned.
Utilize ESRI suite ArcGIS software applications with relational databases including MS Access, Oracle and SQL Server.
Develop, deploy, and maintain GIS applications built with ArcGIS extensions and ArcServer.
Develop mashups with other mapping technologies such as Google Maps and Bing.
Performance tune servers running ArcGIS and databases, including upgrading various server software packages in a timely manner.
Certificates and Licenses
MS Certified SQL Developer preferred