Jobs via Dice
Oracle Lead Developer and Oracle Developer and Pl/Sql Developer
Jobs via Dice, Alpharetta, Georgia, United States, 30239
Oracle Lead Developer and Oracle Developer and Pl/Sql Developer
Our client, Wise Skulls Corp., is seeking an Oracle Developer. Job Details: Title: Oracle Developer Location: Alpharetta, GA (On-site) Duration: 6 months (possibility of extension) Duties and Responsibilities: Works with stakeholders to analyze data needs, design or evaluate solutions and develop databases to meet business requirements Troubleshoots and resolves database integrity issues, blocking and deadlocking issues, connectivity issues, and security issues Troubleshoots Oracle related CPU, Memory, I/O, disk space and other resource contention Manages encrypted databases Conducts performance tuning, query optimization, using Performance Monitor, and other related monitoring and troubleshooting tools Executes backups, restores, recovery models, and database maintenance tasks Writes and troubleshoots SQL Code and designs (stored procs, functions, tables, views, triggers, indexes, constraints) Documents processes and procedures Upgrades database from one SQL version to another SQL version Provides technical support and coordination for core infrastructure components including server, network, storage, and software Experience and Education Requirements: Minimum 5+ years of experience in software development using Oracle SQL, PL/ SQL and Unix Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions Knowledge of Python would be an added advantage. Expertise in database performance tuning and Unix programming Experience in data replication within Oracle and Oracle to other DB. Knowledge on Golden Gate and QLIK replication software Good experience in developing Programs to import data from various sources into Oracle Database tables using PL/SQL, SQL*Loader Experience with ETL process for Data loading from oracle to Data Warehouse Having good experience in deployments and production support of developed applications. Also having customers handling experience Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a dynamic, team-oriented environment Hands-on experience in oracle database design and modeling and query tuning Other Details: Seniority level: Mid-Senior level Employment type: Full-time Job function: Information Technology Industries: Software Development
#J-18808-Ljbffr
Our client, Wise Skulls Corp., is seeking an Oracle Developer. Job Details: Title: Oracle Developer Location: Alpharetta, GA (On-site) Duration: 6 months (possibility of extension) Duties and Responsibilities: Works with stakeholders to analyze data needs, design or evaluate solutions and develop databases to meet business requirements Troubleshoots and resolves database integrity issues, blocking and deadlocking issues, connectivity issues, and security issues Troubleshoots Oracle related CPU, Memory, I/O, disk space and other resource contention Manages encrypted databases Conducts performance tuning, query optimization, using Performance Monitor, and other related monitoring and troubleshooting tools Executes backups, restores, recovery models, and database maintenance tasks Writes and troubleshoots SQL Code and designs (stored procs, functions, tables, views, triggers, indexes, constraints) Documents processes and procedures Upgrades database from one SQL version to another SQL version Provides technical support and coordination for core infrastructure components including server, network, storage, and software Experience and Education Requirements: Minimum 5+ years of experience in software development using Oracle SQL, PL/ SQL and Unix Extensive experience in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages and Exceptions Knowledge of Python would be an added advantage. Expertise in database performance tuning and Unix programming Experience in data replication within Oracle and Oracle to other DB. Knowledge on Golden Gate and QLIK replication software Good experience in developing Programs to import data from various sources into Oracle Database tables using PL/SQL, SQL*Loader Experience with ETL process for Data loading from oracle to Data Warehouse Having good experience in deployments and production support of developed applications. Also having customers handling experience Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a dynamic, team-oriented environment Hands-on experience in oracle database design and modeling and query tuning Other Details: Seniority level: Mid-Senior level Employment type: Full-time Job function: Information Technology Industries: Software Development
#J-18808-Ljbffr