Database Analyst
Location: Tampa, FL or Irving, TX
Works on problems of moderate and varied complexity where analysis of data may require adaptation of standardized practices or precedent.
Acts independently to identify and select appropriate methodologies.
Work customarily and regularly (50% of time or more) requires the exercise of discretion and independent judgment.
Normally receives general instructions on non-routine work assignments.
Requires additional instructions and frequent guidance on new assignments.
Decisions are made independently.
Assigned multiple tasks or projects are generally reviewed after completion.
Contact is typically coordination in nature and involves exchanging detailed technical information. May deal with both internal and external contacts.
Demonstrates working knowledge in job-related functional area and of the business.
Bachelor's degree, or equivalent.
7-10 years of experience
JOB TITLE: Database Analyst
***** DONOT SUBMIT IF MUST HAVE SKILLS DOENST MEET ******
Must have skills: Strong Postgis GIS geometry sql Processing, PostGre SQL, PL/SQL, Performance tuning of GIS data, Shell scripting or python scripting
Good to have: Any Reporting tools
Responsibilities:
Proficient in PostGIS geometry data, Data extraction and storage logic building, Convert the business requirement into technical solutions
Proficient in writing Stored Procedures, Functions, Packages and Triggers using PL/SQL
Proficient in Postgres and PostGIS Database design with relational models and very good experience in entity and attribute identification and developing the Entity-Relationships
Resolve database performance and scalability issues
Implement DB performance tuning and optimization
Design and implement scalable database schemas and configuration
Expertise in using Bulking techniques, Analytical Functions, Hierarchical Queries, Partition utilization to increase performance
Automating data loading, extraction, reports generation using UNIX Shell scripting or Python scripting
Efficient in Optimizing, Debugging, and testing SQL queries, views, and stored procedures written in Oracle and SQL Server
Excellent communication skills.
EDUCATION/CERTIFICATIONS:
Bachelor's degree in Information Systems, Computer Science or related field.