| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Plano, Texas Street Address PHONE NUMBER AVAILABLE EMAIL AVAILABLESUMMARY20 years of working experience as Senior Database Developer in Oracle, PostgreSQL and MySQL databases.Highly proficient in SQL, PL/SQL, Pro*C, dynamic SQL, stored procedures, functions, packages, triggers etc.Extensively worked in database design, development and production support in renowned IT organizations.Strong hands on expertise on performance tuning using Oracle AWR data and performance views.Strong experience in ETL processes and data warehouses using shell scripting and informatica, etc.Strong skills in Unix / Linux shell scripting.Excellent logical and analytical skills in troubleshooting database application issues.Deep knowledge of database concepts and physical / logical architectures.Commitment to excellence proven by an outstanding career track.EXPERIENCEVerizon Communications Irving, Texas January 2006 September 2024Senior Database DeveloperDevelop and maintain a suite of Oracle applications that incorporate mathematical algorithms for optimal network planning. The tools are designed to satisfy growing customer demands while minimize investment costs, which bring multi million dollars of new revenues each year.Create core algorithm using Oracle Pro*C language for network planning. This tool automates many manual operations, and provide network growing forecasts and network planning options.Develop an Oracle Pro*C performance analytic program. This program troubleshoots slow database sessions by analyzing wait events and statistics, identifies the performance bottlenecks, and proposes tuning options.Design and develop ETL applications to extract wireless device utilization data from GCP, transform the data and load the data into Oracle, PostgreSQL and MySQL databases. It provides critical data for network engineers and for sales of 5G wireless services to new customers.Create an Oracle data warehouse that consolidates network data from legacy systems at IBM mainframe and Informix database, transforms the data into consistent formats and stores the data in Oracle database for various dashboards and engineer teams to use.Create data encryption applications for data protection. The applications mask sensitive data in Oracle, PostgreSQL or MySQL for off-shore teams to access.Work on migrating legacy systems into new Oracle based applications. These migrations improve the performance, cutting the overall run time by 50% besides providing new features.Work as application DBA with responsibilities in history data archive and cleanup, complex queries and slow sessions performance tuning and user role management, etc.MCI Worldcom Richardson, Texas January 2001 - January 2006Application DeveloperDeveloped C/C++ based algorithms for network planning optimization using Operations Research skills.Created and maintained a suite of GUI applications using C++, Java and Micsoft Visual Studio C# for network planning engineers.Worked on developing queries, procedures, functions, triggers, views, schema and tables designs.Worked on migrating legacy SAS / mainframe / Informix applications into Oracle based ones with enhanced features and improved performance.SKILLSExtensive Oracle, PostgreSQL, MySQL experiences.Deep understanding of database concepts and architectures.Strong Unix / Linux scripting capabilities.Highly proficient in database languages such as C, Pro*C, PL/SQL, embedded SQL and dynamic SQL, etc.Data Extract, Transform and Load. Strong experience in ETL processes.Performance tuningSQL *Plus, SQL-Loader, PsqlEDUCATIONUniversity of Texas at Dallas Richardson, TexasMaster of Computer Science, with minor in Operations ResearchADDITIONALCertified Oracle Database AdministratorCandidate's Name
Plano, Texas 75025 PHONE NUMBER AVAILABLE EMAIL AVAILABLE |
