SUMMARY:

• Professional background of over twenty(23) years productive and successful experience in Database Administration with a proven track record functioning as an independent consultant. I have completed many projects with full life cycle. MIS team leader/project leader. Team player attitude with the ability to work independently. Possess very good analytical skills. Ability to effectively communicate with peers and management. Ability to mentor/cross - train other DBA’s and associates.
• Provide Database Administration leadership in designing and implementing highly scalable database solutions deliverables.
• Analyze, design and data model solutions for business needs in cooperation with various levels of business and systems personnel(Flow Charting, ERD diagrams, etc.)
• Perform database analysis, design, coding, testing and implementation of database structures.
• Participate in requirement gathering and business requirements. Understand complex data relationships and business requirements to formulate efficient and reliable solutions to difficult problems. End-to-end design and implementation of data modeling and database planning including data warehousing.
• Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems including project planning.
• Review database access code and recommend performance tuning opportunities and system testing.
• Write code to access database.
• Advise less experienced team members in all phases of the assignments and assist in the coordination of team activities.
• Plan, install, configure and perform upgrades of Oracle DBMS software on various platforms.
• Install, test, evaluate, implement and maintain DBMS related system software and tools.
• Design and implement database backup and recovery procedures.
• Monitor and tune database performance including SQL performance tuning.
• Implement effective database security practices and procedures.
• Implement complex enterprise changes as they pertain to the database environment.
• Develop, document and enforce database standards and procedures.
• Maintain and improve high availability and disaster recovery.
• Strong skill in PL/SQL procedures, packages, triggers and replication.
• Work with development and operations staff in resolving problems quickly and efficiently.
• Clear communication and documentation of technical specifications.
• Sharing knowledge by effectively documenting work.
• Load and extract formatted data in and out of database(ETL).
• Migrate data to other databases.
• Recover lost databases.
• Database storage management.
• Finest granularity approach to Oracle implementation and defragmentation.
• I/O distribution analysis.
• Capacity planning, capacity monitoring and management.
• Strong database troubleshooting experience.
• Perform transaction-sizing measurements.
• Managed day-to-day production databases.
• Possess a thorough understanding of Oracle fundamentals, concepts, utilities and applications.
• Seasoned experience with Unix and Linux a strong ability with shell scripting.
• Experience working in large database environments.
• Calculate disk space requirements.
• Oracle’s Enterprise Manager(OEM), Statspack Reports, Explain Plan, SQL Trace, TKPROF and AWR Reports.
• Oracle SQL*Net Network Configuration.
• Volume sized production database with over 45 terabytes of data.
• Install Oracle patches and upgrades.
• Provide Database Administration using SDLC from initial feasibility study through maintenance and development of the completed database and application cycle using conceptual data modeling tools to describe stages of complete database implementation.

TECHNICAL SKILLS:

HARDWARE: IBM Mainframe, DEC VAX, SUN Enterprise & Solaris(2.x, 2.7, 2.8), UNISYS 6000, ALTOS 1000, NCR, HP-9000(9, 10, 11.00), CDC-4000, IBM RS-6000 AIX (4.3, 5.2), Digital Unix, Sequent Dynix, IBM PC, IBM PS/2, IBM Compatible PC’s, Dell PC’s and Macintosh.

SOFTWARE: MS-DOS, UNIX, XENIX, VMS, Novell, SQL*ReportWriter, SQL*Report, SQL*Forms, SQL*Menu, SQL*Loader, Oracle Import and Export, Oracle Enterprise Manager Packs, MOTIF Windows, X-Windows, Microsoft Windows Confidential Professional, Microsoft Windows NT Server, Structured Query ReportWriter(SQR) and PeopleSoft, SQL Query Analyzer, Visual SourceSafe.

LANGUAGES: UNIX Script, DCL, SQL*Plus, PL/SQL, C, C++, Pro*C and Pro*Cobol.

DATABASES and COMMUNICATION: DB2, Oracle (12c, 11g, 10g, 9i, 8i, 8.0, 7.3, 7.2, 7.1, 7.0, 6.0, 5.1b), SQL Server ( 2000.8.00.760 ), Ingress, dBase, DataStage, SQL*Net, DEC*Net, TCP/IP and FTP.

METHODOLOGIES: Yourdon Structured Analysis and Design, Extended Relational Analysis and Design, ERwin Relational Diagramming, SQA Performance Tuning, Configuration and Multi-User Testing.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, Ga

Database Administrator

Responsibilities:

• Responsible for planning, coordinating and administering computerized databases, including base definition, structure, documentation, long range requirements, operational guidelines, protection and application support.
• Ensured accuracy and completeness of data in master files and various support tools such as base dictionaries.
• Established and maintained security and integrity controls.
• Formulated and monitored policies, procedures and standards relating to database management.
• Utilized Oracle RAC, Oracle OEM, Oracle SQL* Plus, RMAN, Oracle 12c, BMC Patrol, SAS, TSM, ASM, VMware, GoldenGate and Dataguard.

Environment: Oracle, Linux/Red Hat June-2011 - Feb-2015

Confidential, Johns Creek, Ga

Database Administrator

Responsibilities:

• Supported a teem of application developers in their day-to-day database creations by creating database objects including snapshots.
• Migrated testing, development and production databases.
• Purged data. Implemented and compiled Oracle functions, triggers and procedure code.
• Created new databases using Oracle version 10g and 11g, removed unwanted database and DB upgrades.
• Granted access permission to developer’s and compiled stored procedure packages and functions.
• Allocated and extended sizes of database objects.
• Ran database performance tools such as AWR reports and performance tuned SQL queries.
• Enrolled and unlocked users to their user accounts. Backed up databases using RMAN. Optimized queries and setup SQL*Net connections.
• Developed Excel speed sheets for clients that calculated mathematical formulas such as percentages.
• Utilized Oracle Import and Export Utility, SQL* Plus, PL/SQL, SQL*Net, OEM, RMAN, Oracle 10g, 11g, FTP and Microsoft Excel.

Environment: Oracle, Microsoft Windows Confidential

Confidential, Atlanta, Ga

Database Administrator

Responsibilities:

• Responsible for maintaining SQL Server databases under Windows Confidential .
• Wrote T-Sequel code.
• Worked with analysis to discover and design the business process of Pipeline, which is designed to manage our nation’s delivery flow Pipeline infrastructure. Altered table structures of Oracle 9i skeleton and objects.
• Utilized Oracle’s import and export utility to migrate databases to other platforms.
• Created PL/SQL and SQL Server stored procedures. Setup SQL*Net connections.
• Performance tuned SQL statements and Oracle’s SGA area.
• Utilized Microsoft Windows Confidential Professional, Oracle v 9.2.0.7, SQL*Plus, SQL Server v. 2000.8.00.760 , Oracle SQL-Developer, SQL-Server Developer, SQL Query Analyzer, Visual SourceSafe.

Environment: Oracle, Sun Solaris, Microsoft Windows Confidential

Confidential, Atlanta, Ga

Database Administrator

Responsibilities:

• Responsible for the installation and building of an Oracle 10g(10.1 & 10.2) application on a RAC server.
• Designed a high performance OLTP database in Oracle.
• Utilized ERWin case tool to design the database and generated DDL statements. Used Oracle Explain Plan, TKPROF analysis for indexing strategy.
• Worked with developers to explain Oracle features and created and enhanced database design.
• Created and volume sized database tables, indexes, tablespaces and all database objects.
• Tuned Oracle queries for a data warehouse and created Star Schema design and used bit-map indexes on a database sized more than 1 terabytes.
• Performance tuned, monitored, troubleshoot and resolved problems using Oracle Stat Pack analysis tool in a 24x7 production environment.
• Created materialized views and used Oracle Summary Advisor. Used Oracles warehousing feature of partitioning tables.
• Implemented Oracle Streams that replicated changes at the database level between two databases.
• Created UNIX shell scripts and used Oracle tools such as SQL*Loader, Export and Import utility.
• Implemented Oracle security features of encryption and VPD(virtual private databases).
• Utilized Sun Solaris Unix, Linux, Microsoft Windows Confidential Professional, ERWin, Oracle 9i, 10g, Oracle RAC, Unix Script, SQL*Plus, Sql*Loader.

Environment: Oracle, Sun Solaris, Microsoft Windows Confidential

Confidential, South Orange, N.J

Database Administrator

Responsibilities:

• Responsible for the implementation of a software package called Banner. Banner is a Portal application that runs on top of Oracle.
• Responsible for the installation of Oracle 9i production database.
• Specified appropriate storage specifications for indexes, tables, tablespaces and rollback segments using Oracle's autoextend management feature.
• Automatic Storage Management(ASM) administration that referenced disk groups for balanced storage and redundancy using raw and cooked file systems.
• Analyzed the performance for the database and performance tuned the database.
• Installed SQL*Net communications between a Unix server and Windows Confidential clients. Setup backup and recovery procedures using RMAN.
• Installed Oracle 9i PC on a Windows Confidential client.
• Consulted and taught Oracle relational database methods and concepts to management and a DBA associate.
• Utilized Sun Solaris Unix, Linux, Microsoft Windows Confidential Professional, Oracle 9i, Unix Script, SQL*Plus, OEM, RMAN.

Environment: Oracle, Sun Solaris, Microsoft Windows

Confidential, Garfield, NJ

Database Administrator/Data Modeler

Responsibilities:

• Gathered and analyzed data and business requirements.
• Created ERWin ERD specifications for a data warehouse database to discover table relationships and database integrity constraints.
• Responsible for installation of Oracle version 8i and 9i production databases.
• Specified appropriate storage specifications for indexes, tables and tablespaces partitioning in ERWin’s case tool method.
• Created stored procedures and triggers. Installed and implemented a data load model between an IBM AS/400 and Oracle database using DataStage.
• Performance tuned database, query optimized and stress tested Popular Club’s production database using Oracle’s Statpack diagnostic and analyzing report which allowed me to anticipate unusual performance conditions by defining thresholds and alerts to respond to special situations as soon as they occur or to enable automatic database responses.
• Volume sized teradatabase production database with over 45 terabytes of data in a 24x7 production environment.
• Specified I/O distribution using a capacity plan model and measured throughput.
• Setup backup and recovery procedures using RMAN. Utilized SUN Solaris Unix with RAC, Microsoft Windows Confidential Professional, Oracle 8.0, 8i and 9i, Unix Script, SQL*Plus, SQL*DBA, OEM, Oracle’s Export & Import Utility, SQL*Loader, RMAN, ERwin, Oracle’s Discoverer Ad Hoc Tool, DataStage, TCP/IP and FTP.

Environment: Oracle, Sun Solaris, Microsoft Windows 95