Oracle Developer, Lead

Location: Wilmington DE or Alpharetta, GA Duties and Responsibilities: • Works with stakeholders to analyze data needs, design or evaluate solutions and develop databases to meet business requirements • Troubleshoots and resolving 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) • Documentations 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 8+ 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.