Job Description :
Title: Data Scientist, Database Development & Performance specialist
Location Alpharetta, GA
JOB DUTIES:
UPDATE: Title: least 8-9 years of DB Dev experience.
ETL, DBA
2 to 3 years of experience in informatica
* Analyze architecture, including relationship between database tables and relationships of business data stored
* Analyze database design to understand impact on performance
* Recommend target database solution based on business and/or technical requirements – such as RDBMS vs. No SQL database
* Create high-performing database designs/code to retrieve large datasets and optimize system resources
* Tune poor performing SQL to run at optimized levels; exercise intermediate to advance practices to identify poorly performing code and identify areas to improve it
* Demonstrate capability to write DDL and SQL of low to medium complexity
* Execute database statements from Java code, including SQL statements, prepared statements, and stored procedures
* Analyze data, automate monitoring of very large datasets to identify data anomalies early to minimize impact to customer facing data, and write code to reconcile
* Encrypt data to restrict visibility of sensitive information
* Manage database updates across lower environments
Testing
* Create and execute test plan to exercise functional and technical requirements.
Release Support
* Verifying database schema and data patches applied correctly
* Monitoring database activity and log activity during release testing
* Investigate issues found during a release, assess customer and system impacts
MUST HAVE SKILLS:
* Development experience with
- Oracle 10g
- PostgreSql
* Database development IDE (Toad, Oracle SQL Developer, or other)
* SQL, DDL, Explain plan analysis
* Experience with all phases of the Software Development Life cycle, including system analysis, design, coding, testing, debugging and documentation
* Excellent written and verbal communication skills
* Team player, collaborative
* Delivers excellent quality of code and documentation
* Critical thinker, good problem solver
* Can deliver assigned work independently
DESIRED SKILLS:
* Cassandra design, development experience
* Elastic design, development experience
* Java
* OOM framework
EDUCATION/CERTIFICATIONS:
BS in computer science, information systems, or other technical field is a plus but not required