SUMMARY:

• She is a proven Lead Database Administrator and Oracle Developer with more than 15 years of IT experience including the deployment and management of mission critical 24x7 databases.
• In her last position at Confidential she has been as Oracle Database Development DBA/Lead Maintenance DBA.
• The last Nine years was spent writing SQL, PL/SQL, Oracle 10g /11g/12c database creation,ODA X4 - 2, upgrading the database, CPU's, PSU's, Oracle Steams, Golden Gate, Oracle APEX, XML, preparing master scripts, deployment, Backups, RAC, SQL tuning, PL/SQL tuning, Data Modelling, Unix shell scripting, Oracle AS 10G/11g, 12c Oracle WebLogic Servers, Oracle Reports in order to develop the required applications and automate jobs. Her communication skills are excellent and also she is certified oracle 10/11g/12c Professional.

TECHNICAL SKILLS:

Oracle DBA: Oracle 12c/11g/10g/9i,Oracle Application Server 9iAS/10g/11g R2 iAS,Oracle 10g RAC,ODA,Mongo DB

ETL Tools: Erwin 4.x, Data Junction 7.5, Informatica and Data stage.

Tools: Crystal Reports, Erwin 4.0/3.5.2, MS-Office, Microsoft Word, Excel, Power Point,, TOAD, Designer 9i/2000, Discoverer 9iAS,Version Manager,PVCS Tracker

Environment: Sun Solaris UNIX 5.9, HP UNIX B.11.00, Windows XP / 2000 / NT, Windows 2000 Advanced Server, LINUX 3/4/5/6,Winodws 2003,windows 2008

RDBMS: Oracle 12c/11g/10g /9i / 8i, MS Access, SQL Server 2000,, Teradata, Oracle 10g/11g AS, Oracle9iApplication Server, Application Server 10g,MYSQL 5.1

Programming: C, SQL, PL/SQL, VBScript, HTML, DHTML, XML,ASP,JSP, Visual Basic 5.0/6.0

Oracle Utilities: External Tables, Import, Export, Data Guard, RMAN, Oracle Enterprise Manager, Oracle 10g/11g/12c Grid, AWR, Stats pack, Explain Plan,ADDM,EXPLAIN PLAN

Reporting Tools: Business Objects, Crystal Reports 8.0,Oracle Reports

PROFESSIONAL EXPERIENCE:

Confidential

Lead Database Administrator

Responsibilities:

• Installed, configured, migrated, upgraded and conducted troubleshooting of various Oracle products, including Oracle database servers and Oracle application servers. Installed and administered 4- node Oracle10g RAC architecture in Linux.
• Upgraded Oracle 10g RAC database 4 Node RAC ocfs2 file system to Oracle 11g RAC 4 Node ASM file system. Removed 2 Nodes from 4 Nodes PROD RAC. Recovered database when the databases down to due space full or some other hardware related issues.
• Configured Oracle APEX 4.2.1 in Linux environment by using APEX listener and Embedded PL/SQL gate way. Upgraded Oracle APEX from 4.2.0 to 4.2.1 and Oracle APEX from 4.2.1 to 4.2.2.
• Implemented Oracle 11g Streams in OPP environment. Resolved Oracle Streams apply and capture process errors. Involved in upgrading SAN (hardware). Supporting to the developers when there is any issue related to the deployments or Database side issues.
• Upgraded Oracle 10g Grid to 11g Grid. Installed Oracle 12c GRID for to monitor the databases. Upgraded the Oracle 1g Agents to 12c agents in all monitoring databases.
• Applied SPU and PSU patches to all OPP environments. Resolved OPP security related vulnerabilities in all OPP databases. Upgraded Oracle 11g RAC database from 11.2.0.1 to 11.2.0.3 11 g RAC.
• Upgraded Oracle 10g Application Servers to Oracle 11g Weblogic servers. Deployed all applications from Oracle 10g Application Server to Oracle 11g weblogic servers. Supported to the development team in tuning the SQL statements and resolving performance issues.
• Administered database security, user schemas, and database development processes. Installed and administered two Oracle9iAS (Portal) production sites and one Oracle9iAS (Portal) development/test sites on Windows NT, and upgraded them to OracleAS10g.
• Installed, configured, migrated, upgraded and conducted troubleshooting of various Oracle products, including Oracle database servers and Oracle application servers. Installed and administered 4- node Oracle10g RAC architecture in Linux.
• Administered database security, user schemas, and database development processes. Installed and administered two servers of Oracle9iAS (Portal) production sites and one Oracle9iAS (Portal) development/test sites on Windows NT, and upgraded them to OracleAS10g.
• Provided technical support for all application administrators and users. Applied critical patches to Oracle databases and application servers. Installed Oracle Cluster ware Software to set up 4-nodes in a production environment. Upgraded an Oracle 10g RAC Release 1 4-node set up to an Oracle 10g RAC Release 2 database and PROD releases.
• Implemented the changes to the production environments based on directions received from the development team in order to upgrade the applications from the development/test environment to the production environment. Applied the Quarterly CPU Oracle patches to the development, test and production databases and oracle application servers. Reviewed the application and database design documents developed by development team. Implemented and Monitored RMAN and export/import backups everyday in the production, test and development databases.
• Worked in adding in node and deleting node in Oracle 10g RAC. Testing Oracle 11g RAC features in the Sand Box environment and validating compatibility of our applications. Upgrading the Oracle 10g R2 RAC to 11g R2 RAC with ASM database in the Sand Box environment. Worked with Oracle Support (Metal ink) for issues resolutions.
• Rebuilt a 2-node RAC databases due to a SAN crash and recovered the 4-node production database after the SAN recovered with latest RMAN backups. Designed, developed, and implemented database security management, backup/recovery strategy, monitoring methods, and performance tuning. Provided technical support for all application administrators and users. Applied critical patches to Oracle databases and application servers. Installed Oracle Cluster ware Software to set up 4-nodes in a production environment. Upgraded an Oracle 10g RAC Release 1 4-node set up to an Oracle 10g RAC Release 2 database. Implemented Oracle Label security by using the row level label security.
• Installed the Oracle APEX 4.0 in the LINUX 4.0 and windows standalone machine. Upgraded Oracle 10g R1 to Oracle 10g R2 in the RAC environment. Applied quarterly CPU patches to the DEV, TEST and PROD databases and Application Server. Upgraded the Oracle Application server from 10g R1 to 10g R2. Worked with oracle support if we have any application or database issues.

Environment: Oracle 12c/11g/10g/9i,ODA X4-2, ODA Bundle Patch,Toad, Linux RHEL AS 3/4/5/6 Update 4, PVCS, Version Tracker, Oracle 9i/10g/11g AS, Oracle 10g AS(R2/R3), XML-RPC, Oracle Label Security, PROD deployments, Oracle 10g/11g/12c Grid, Oracle 10G R1 RAC, Oracle 10g R2 RAC,Maven, OBIEE, Windows NT, Business Objects, Documentum, J2EE, OID, Apache, Portal, Power Builder, OC4J,Lotus Notes, Oracle APEX, Erwin, Oracle 11g R2 RAC, ASM, WEB logic Server, Oracle APEX 4.0.2,MySQL 5.1

Confidential

Database Administrator

Responsibilities:

• Created and maintained all databases required for development, testing, and production usage. Administered all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. Provided technical support to application development teams.
• Created several procedures, functions, triggers, and packages to implement functionality in PL/SQL. Created database indexes, integrity constraints, and triggers. Participated in creating a database a model, and normalized and documented using Erwin. Migrated the database from Oracle 8i to Oracle 10g, and created backups by using RMAN. Created user & table spaces, indexes, and database links. Conducted performance tuning, disk space monitoring, and file transferring using FTP.
• Database management include physical storage management such as data files, control files and redo log files in DEV and UAT environment. Good understanding of database cloning using either Oracle export utility or using cold backup.
• Performance Tuning for long running queries using STATSPACK, AWR reports, analyze, DBMS STATS, SQL trace, explain plan. Re-designing of tables into partitioning tables. Analyzing existing table structures and fine tuning if required.
• Implemented automatic database backup procedures on Windows platform using cold backup strategy as well as using Oracle Export utility. Daily monitoring of Oracle trace files for any Oracle errors, checking and resolving database locks.

Environment: Oracle 8i/9i/10g, TOAD, Linux, Erwin, SQL * Loader, PL/SQL, KSH Script, SQL Server 2000, WS FTP, Windows.

Confidential, Besthada, MD

Sr. Programmer Analyst

Responsibilities:

• Understanding of high level requirements (business & functional), Subject area diagrams related to Next Generation System, Sales Decision Support, Pricing Revenue Opportunity Model, Event Satisfaction Survey.
• Developed shell scripts and Oracle PL/SQL procedures for generating .zip files and automatically populating data in to the tables as and when requested.
• Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL. Created SQL Load Scripts to load data from flat files to ORACLE 10g.Created Indexes, Integrity constraints, Triggers on the database. Used EXPLAIN Plan, TKPROF, SQL * Trace for tuning SQL Queries.
• Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots. Writing the Perl scripts to load the data from upstream system to oracle. Creating the jobs and process new files to main frame system by using the Unix Shell Scripts.
• Walked through the Logical and physical Data Models of all source systems for data quality analysis. Extensively used Erwin forward engineering of the data models to create DDL scripts for the purpose of generating metadata, keys, constraints, indexes of the existing database for the purpose of data analysis and mining.
• HTML scripting, including the ability to run Oracle stored procedures from passing and returning parameters. Analyzed on database structure, space requirements, data growth, delta of Change and Generated database minimum requirements. Conducted meetings and reported projects status to Manager and Business Leads.

Environment: Oracle 8i/9i/10g, TOAD, HP/UX, Erwin, SQL * Loader, PL/SQL, KSH Script, Oracle XML, UNIX Shell Scripting, Teradata, Perl Scripting, Informatica 7.1

Confidential, Memphis- TN

Sr. Programmer Analyst

Responsibilities:

• Understanding of high level requirements (business & functional), Subject area diagrams related to Customer management, marketing, sales and forecasting. Involved in creating database model, normalizing and documenting using Erwin.
• Wrote Fast Load scripts, SQL Queries to extract large volume data (ETL) from Confidential Teradata Box. Created several Procedures, Functions, Triggers and Packages to implement the functionality in PL/SQL.
• Created SQL Load Scripts to load data from flat files to ORACLE 9i.Created Indexes, Integrity constraints, Triggers on the database. Used EXPLAIN Plan, TKPROF, SQL * Trace for tuning SQL Queries. Database involved minimum of 8 Gig of data in the smallest table and at least 30 mil rows in volume and maximum of 100 Gig of data in a table and at most 405 mil rows in volume for history of 24 months.
• Creating the tables and loading the data by using SAS from Teradata to oracle and oracle to Teradata.Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots.
• Developed some reports by using the oracle reports 6i.Writing the Perl scripts to load the data from upstream system to oracle. Writing the Unix Scripts to automate the process to load the data from upstream systems to oracle. Enabling the cronjob to refresh by monthly, weekly snapshots.
• Analyzed on database structure, space requirements, data growth, delta of Change and Generated database minimum requirements. Conducted meetings and reported projects status to Manager and Business Leads.

Environment: Oracle 9i, Teradata, DB2, Sun OS 5.8,LINUX, Query man 6.0, Erwin, Fast Load, KSH Script, SAS 9.1.0, Toad, SQL * Loader, BTEQ, RMAN, ORACLE 9iRAC, Oracle XML, Oracle Tools.

Confidential, Chicago

Database Administrator

Responsibilities:

• Understanding of high level requirements (business & functional), Subject area diagrams related to portfolio management, loans processing/monitoring, credit management, risk management and underwriting segments for decision making and reporting in the design of an integrated credit reporting system.
• Performed extensive data mining and analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized credit monitoring system from several heterogeneous source systems. (Loans in Process, Risk Management, Commercial, Real Estate and Financial Analyzer systems).
• Creating and managing database objects such as tables, views, materialized views and indexes. Finding and re-validating invalid database objects using scripts. Involved in the design of tables, forms and reports. Extensively used Forms 5.0 used for designing Screens and Reports 3.0 for generating reports.
• Implemented business logic by PL/SQL Stored Procedures/Functions in the backend. Designer 2000 was used to business process modeling. Walked through the Logical and physical Data Models of all source systems for data quality analysis.
• Extensively used Erwin forward engineering of the data models to create DDL scripts for the purpose of generating metadata, keys, constraints, indexes of the existing database for the purpose of data analysis and mining.
• Extraction of Source systems tables (5 Oracle and 2 SQL servers) and data into DQI environment for quality analysis and anomaly detection. Worked on data mining to alleviate data inconsistencies and data anomalies issues with validations of the keys, constraints, indexes and potential joins across schemas.
• Performed DBA activities includes creation of users & table spaces, indexes, Creation of database Links, performance tuning, disk space monitoring and File transfers using FTP.

Environment: Oracle 9i (9.0.1)/8i (8.1.7.0.0), Teradata, Windows2000, Erwin 3.5.2, TOAD, Data Quality Inspector 2.13,MS PowerPoint, Excel, SUN Solaris 2.7, PL/SQL Developer, Unix Shell Scripting, Ascential Data Stage 7.0, Linux.

Confidential

Database Administrator

Responsibilities:

• Obtained an understanding of high level requirements (business & functional), portfolio management subject area diagrams, loans processing/monitoring, credit management, risk management, and underwriting segments for decision making and reporting in the design of an integrated credit reporting system.
• Performed extensive data mining and analysis of metadata to test the integrity, consistency and appropriateness of the data to be brought into the centralized credit monitoring system from several heterogeneous source systems (Loans in Process, Risk Management, Commercial, Real Estate and Financial Analyzer Systems).
• Participated in the design of tables, forms, and reports. Extensively used Forms 5.0 for designing Screens and Reports 3.0 for generating reports. Implemented business logic PL/SQL stored procedures and functions in the system backend. Created user & table spaces, indexes, and database links. Conducted performance tuning, disk space monitoring, and file transferring using FTP.
• Conducted new technology evaluation. Managed DBA training requirements and the promotion of cross-divisional synergy. Assisted with resource planning, interviewing, personnel reviews, and arranging DBA coverage throughout the organization. Mentored and tutored junior DBAs and provided assistance to developers. Maximized Oracle skills in order to publish best practices for the organization.
• Participated in gathering system user requirements, data modeling, and data development. Created E-R and data flow diagrams. Created functional and technical specifications for data entry screens and reports. Assisted with the creation of schemas, database triggers, and stored procedures.

Environment: Oracle 9i(9.0.1)/8i(8.1.7.0.0), Teradata, Windows2000, Erwin 3.5.2, TOAD, Data Quality Inspector 2.13,MS PowerPoint, Excel, SUN Solaris 2.7, PL/SQL Developer, Unix Shell Scripting, Ascential Data Stage 7.0, Linux., Developer 2000, SQL *LOADER, Visual Basic 6.0, SQL, PL/SQL, UNIX, Windows 95/98/NT, RMAN, Toad.