Lead Database Developer Resume Profile, FL - Hire IT People

Professional Summary

Expertise in Oracle replication products such as Oracle Streams, Goldengate, Oracle Advanced queues, Advanced replication, Updatable Materialized views, and change data capture CDC .
Well versed with replication setups, best practices, monitoring and troubleshooting techniques, solution architecting, and conflict resolution.
Expertise in Advanced queues AQ , Asynchronous notifications, distributed operations, Ora-7445 ora-600s, sessions tracings, SQL and PL/SQL, and Tuning.
Experienced in Performance tuning utilizing SQLT, AWR, ASH, Explain Plan, Tracing- oradebug and 10046, SQL advisor, SQL profiles and SQL baselines.
Experienced in Application tuning and Database tuning in Exadata and non-exadata environments.
Well versed with process tuning utilizing PL/SQL and scheduler jobs. Has prior experience tuning a process from 20 hours of execution time to 30 minutes.
Has experience tuning processes with execution times in the rage of 50ms-200ms.
Good experience in tuning Goldengate processes, Logminer, and Streams processes.
Has good knowledge of tuning in distributed environments involving two or more databases, and troubleshooting deadlocks and hangs.
Good knowledge of Oracle internals and troubleshooting methodologies.
Has extensive expertise in implementation of large-scale applications within Data warehousing and in data analysis using SQL and PL/SQL.
Well-versed with quality procedures and Software development life cycle SDLC processes.
Multi-Platform experience with interest and ability to learn and apply new technologies.
Good communication skills and extensive documentation experience.
Extensively knowledge on Incident management, problem Management and change management.
Viable skills of project management, good Leadership qualities and a good team player.
Hands on experience in Offshore-Onsite model and good skills of interacting with business.

Technical Skills

DATABASES : Oracle 8i/9i/10g/11g, SQL server, and Teradata.
Oracle Products : Oracle Streams, GoldenGate, Exadata, RAC, ASM, RMAN, OEM, Advanced replication, Updatable Materialized views, Advanced Queues, CDC, XA, Database links and Tuning techniques.
Languages : PL/SQL, Shell Scripting, and Perl Scripting.
GUI : VB 6.0
Web Related : J2EE, ASP, JavaScript, VBScript, and HTML.
Operating Systems : Linux, UNIX, and Windows

Experience Summary:

As a Principal support Engineer,

Provide consultancy and technical support to customers for resolution of problems related to the installation, recommended maintenance, patching and migration, and use of Oracle products.
Currently working as a principal support engineer in Oracle Engineered systems team supporting Oracle Exadata.
Have experience in Oracle Goldengate, Oracle Streams, Exadata, RAC, ASM, RMAN, OEM, Advanced queues, Advanced replication, Materialized views, XA, CDC, distributed operations, DB tuning, SQL tuning, Ora-600s/Ora-7445,etc.

Confidential

Client: AT T wireless

As a Lead database developer,

Designed, developed and implemented data replication Oracle-Oracle utilizing Goldengate and PL/SQL.
Designed and developed filters at the source to eradicate the unwanted changes.
Involved in database tuning, SQL tuning and process tuning utilizing, sql advisor, traces, and explain plan.
Optimized the Wayport processing from 20 hours to 30 mins utilizing, Explain plan, PL/SQL and scheduler jobs.
Successfully optimized the execution times of APIs during peak load from 300ms to 50 ms.
Designed and developed the audit process to validate the data in target system.
Designed and Developed automated monitoring jobs and intelligent APIs to schedule jobs depending on the load.
Involved in Tuning of the APIs to achieve high speed and good response time for the end customers.
Automated reports generation using shell and Pl/SQL.

Environment: Oracle 10g, HP-UNIX, XML, and GoldenGate.

Confidential

Involved in design, development and implementation of software applications utilizing Oracle database and PL/SQL. Lead a team of twelve resources to support applications involving Oracle database, Data warehousing, client server and reporting technologies.

As a Lead,

Managed day to day support activities of 40 applications utilizing Oracle database product.
Managed team and interacted with clients for requirement analysis, Work prioritization and unit testing.
Reduced the month end jobs execution time from 36 hours to 12 hours.
Applications Framework includes data warehousing, Multi tier applications in Oracle, UNIX shell scripting, VB COM, J2EE, SQL Server DTS, Crystal reports etc.
Developed automated paging system incase of job failure and automated messaging system for control report delivery for business validations during the priming process.

Involved in Effort estimation, project bidding, and resource allocation.

Environment: Oracle 10g, SQL Server , Teradata,VB6, Unix AIX 5.2. and Crystal reports.

We provide IT Staff Augmentation Services!

Lead Database Developer Resume Profile

FL

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship