Previous Job
Previous
Jr. Data Scientist, Jr. Database Development & Performance specialist
Ref No.: 18-05868
Location: Alpharetta, Georgia
Long Term Contract
Jr. Data Scientist, Jr. Database Development & Performance specialist

No Corp. to Corp. or 3rd party
Onsite position, onsite interview Required.

Description:
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 coordinative 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. 3-5 years of experience
The team member in this role will work on database systems critical to a great customer experience in or self service channel (web portals and mobile application).
JOB DUTIES:
* 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
Description:

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 coordinative 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. 3-5 years of experience

The team member in this role will work on database systems critical to a great customer experience in or self service channel (web portals and mobile application).


JOB TITLE:

Jr. Data Scientist, Jr. Database Development & Performance specialist


JOB DUTIES:

* 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


REQUIRED SHIFT:

9am ET - 6pm ET


EDUCATION/CERTIFICATIONS:
BS in computer science, information systems, or other technical field is a plus but not required
REQUIRED SHIFT:
9am ET - 6pm ET