Job Description :

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.

             

Similar Jobs you may be interested in ..