TECHNICAL SKILLS

ORACLE 12C, Oracle Cloud Control 12C, ORACLE 11G, ORACLE 10G, Oracle 9i, ORACLE 8i, Oracle SQL Plus, Oracle Enterprise Manager, Oracle 11G RAC, Oracle 11G ASM and Grid Infrastructure, Oracle Label Security, Oracle Audit Vault, Oracle Database Vault, Oracle Connection Manager, Solaris 10, Solaris Zone Technology, Oracle OID, Siebel OBIEE, Oracle 11G Grid Control, ERWIN MODEL MART, SUN SOLARIS UNIX, RED HAT LINUX, AIX, HP UNIX, TERADATA V2R5, TERADATA SQL ASSISTANT, TERADATA ADMINISTRATOR, TERADATA MANAGER, TERADATA PERFORMANCE MONITOR, TERADATA CLIENT TOOLS: FAST EXPORT, MULTI LOAD, BTEQ, MS SQL SERVER 2000, MS SQL SERVER 7.0, MS VISUAL INTERDEV, MS VISIO, BUSINESS OBJECTS CRYSTAL REPORTS, MACRO MEDIA DREAMWEAVER, IIS, SYBASE INFOMAKER, IBM Z/OS MAINFRAME, WINDOWS 2000, WINDOWS XP, WINDOWS NT 4.0, WINDOWS 9X, CONNECT DIRECT DATA WAREHOUSING, LUMIGENT LOG EXPLORER, SQL, T SQL, MS EXCEL, MS ACCESS, CAPABILITIES MATURING MODELS, SDLC, EXTRACT TRANSFER LOAD USING DTS PACKAGES, HUMMING BIRD FTP

EMPLOYMENT

Senior Principal Consultant

Confidential

• Database migration of multi-terabyte database from Oracle 10g NetApp system to Oracle 11G Exadata Super cluster w/Exadata Expansion Rack.
• Daily database performance monitoring of Exadata Super cluster Environment using Cloud Control 12C.
• Administer ASM, RAC, and Grid components of a multi-terabyte database.
• Apply patches and performance tune Exadata databases.
• Devise backup strategy for Exadata Super Cluster environment.
• Using 12C Cloud Control support teams implementation of the Security Technical Implementation Guide STIG and assure implementation of set rules, checklists, and other best practices mechanisms to ensure compliance with government mandated security requirements.
• Configure STIG Enterprise Compliance Monitoring tool and Score Card Reporting within Cloud control.
• Assist Oracle Advanced Customer Support team with faulty hardware replacement and/or hardware upgrades of Exadata and Super Cluster components.
• Test impact of OS configuration changes on database systems using Solaris 11 Bootable Environments
• implemented using Oracle VM server LDOM logical domain Sparc based virtual servers.
• Administration of Storage using Oracle Solaris Browser User interface to manage ZFS 7320 and 7420 storage controllers.
• Using ZFS BUI, take critical backups of ZFS configuration, Infiniband Configuration, and OS Patch Bundle History.

Confidential

Lead Senior Oracle DBA

• IBM Global Business Solutions - Public Sector
• Serve as Production Oracle DBA Team Lead
• Create Standard Operating Procedures for both Production and Non-Production DBA staff
• Engage in Performance Tuning Tasks thru out the life of mission critical production enterprise applications which have Oracle backends.
• Create detailed and peer review detailed Oracle maintenance window related tasks scheduled for the weekends.
• Act as a mentor to Junior Oracle DBA staff members on the IBM/Government project.
• Engage in technical discussions with VP's, Senior Project Managers, and Senior
• technical team members to discuss upcoming initiatives, in an effort to set technical expectations, mile stones, and deadlines for Department of Justice
• Unified Financial Management Division which includes mission critical Oracle Databases being used by DEA, ATF, FBI, and US Marshalls Service
• Create Unix Shell scripts to automate routine DBA tasks
• Daily Administration of Oracle 10G and 11G Instances
• Configure and Administer Oracle 11G Physical and Logical Dataguard Environments
• Complete 11G Enterprise Database installs, install patches on various OS: Windows, Linux, AIX, Sun Solaris
• Install and configure Oracle Grid Control Agent
• Monitor and manage Oracle instances using a variety of Oracle tools: Oracle Grid Control, OEM Java version, SQL Plus, Oracle Developer, and Toad
• Replicate entire database environments on demand using Oracle Recovery Manager and/or Oracle Export/Import methods
• Schema object management: create tables, views, indexes, tablespaces, users, schema owners, materialized views, and stored procedures
• Performance Tune queries using SQL Access Advisor, SQL Tuning Sets, SQL Tuning Advisor
• Rebuild indexes and tables as needed based on fragmentation
• Develop SQL scripts to perform admin work
• Perform Oracle Client Installs as needed and properly configure tnsnames, listener, and sqlnet.ora files
• Use Oracle Utilities to configure enterprise environment: Listener Control, Enterprise Manager Control, Agent Control Utility, Oracle Universal Installer
• Perform logical backup of databases using Export/Import Dumps, and user Export Data Pump when needed
• Intermediate Unix System Administration
• Develop and maintain Database Standards
• Act as lead Oracle technical resource when implementing COTS packages, act as Oracle resource for different Project Managers and Consultants
• Interview stakeholders and managers when introducing new Enterprise Applications which use Oracle as a backend. Help to determine best practice, capacity planning, storage growth, and workload planning
• Manage Oracle Backups and archive logs using RMAN
• Data Replication using Recovery Manager
• Data Replication using Oracle Data Guard, assure that transaction logs between primary and standby servers are in sync, eliminate gaps in Archivelogs when necessary
• Perform night and weekend database admin work as needed during maintenance windows and off peak hours
• Perform SQL analysis on execution plans, Oracle SQL Reports, Statpak
• Performance Tune Databases
• Complete Database Rebuilds as needed
• Monitor Tablespace and Index Fragmentation
• Control monitor database performance degradation, monitor database activity, increase tablespace size as needed

Confidential

Senior Oracle DBA

• Complete 10G Enterprise Database installs, install patches on various OS: Windows, Linux, AIX, Sun Solaris
• Install and configure Oracle Grid Control Agent
• Monitor and manage Oracle instances using a variety of Oracle tools: Oracle Grid Control, OEM Java version, SQL Plus, Oracle Developer, and Toad
• Replicate entire database environments on demand using Oracle Recovery Manager and/or Oracle Export/Import methods
• Schema object management: create tables, views, indexes, tablespaces, users, schema owners, materialized views, and stored procedures
• Performance Tune queries using SQL Access Advisor, SQL Tuning Sets, SQL Tuning Advisor
• Rebuild indexes and tables as needed based on fragmentation
• Develop SQL scripts to perform admin work
• Perform Oracle Client Installs as needed and properly configure tnsnames, listener, and sqlnet.ora files
• Use Oracle Utilities to configure enterprise environment: Listener Control, Enterprise Manager Control, Agent Control Utility, Oracle Universal Installer
• Perform logical backup of databases using Export/Import Dumps, and user Export Data Pump when needed
• Intermediate Unix System Administration
• Develop and maintain Database Standards
• Act as lead Oracle technical resource when implementing COTS packages, act as Oracle resource for different Project Managers and Consultants
• Interview stakeholders and managers when introducing new Enterprise Applications which use Oracle as a backend. Help to determine best practice, capacity planning, storage growth, and workload planning
• Manage Oracle Backups and archive logs using RMAN
• Data Replication using Recovery Manager
• Data Replication using Oracle Data Guard, assure that transaction logs between primary and standby servers are in sync, eliminate gaps in Archivelogs when necessary
• Perform night and weekend database admin work as needed during maintenance windows and off peak hours
• Perform SQL analysis on execution plans, Oracle SQL Reports, Statpak
• Performance Tune Databases
• Complete Database Rebuilds as needed
• Monitor Tablespace and Index Fragmentation
• Control monitor database performance degradation, monitor database activity, increase tablespace size as needed

May 2007 Dec 2009 Teradata Datawarehouse Administrator

Navy Federal Credit Union

DBA support functions related to the design, implementation and maintenance of Teradata databases in Development, Testing, and Production environments. Create users, establish roles, creates database structures. Work with developers to promote their code and solve day to day issues. Work closely with the development groups on database design and implementation projects. Maintain backup and recovery plans and be part of an on call rotation providing 24x7 support across the enterprise. Participate in maintaining documentation and standards for DBA tasks. Evaluate features of Teradata related products, and make recommendations for future activities and tools. Work closely with the Decision Support application development teams to tune and refine Teradata SQL and the SQL behind reports Participate in the definition, review, and execution of Data Management, Meta Data, ETL Extract, Transform, and Load , Data Warehousing, and Business Intelligence architecture, deliverables, strategies, standards, and best practices. Works closely with Business Intelligence management and staff to ensure highly functioning Business Intelligence/Data Warehouse solutions. Develop and tune database environments to ensure performance and service delivery expectations are met. Familiarity with multi amp Teradata environments, and diagnosing and resolving skewed queries. Monitors database statistics and other application specific parameters to maintain performance of the system. Perform ETL duties for NFCU monthly marketing campaign extracts using various teradata tools such as Multiload, Fastload, and Bteq when needed. Perform adhoc ETL duties to extract data from Teradata systems and load data to other proprietary database platforms such as Oracle, Sql Server, DB2, etc. Participates in the resolution of critical and complex design and implementation issues across projects. Keeps up-to-date on Business Intelligence tools, technology, and Data Warehouse database concept developments.

Confidential

Oracle Database Administrator

• Provide database administration support for all Oracle 10G database instances
• Run SQL scripts against Development, Validation, Integration, and Production environments
• Create new databases as needed
• Adhoc querying using SQL, loading data using desktop applications such MS Access, MS Excel
• Test out database modifications prior to the changes being rolled out to Production
• Create and modify database scripts
• Create database objects users, schemas, tables, indexes, materialized views, synonyms
• Modify Logical and Physical Data Models using Erwin
• Prepare databases to be moved through the development life cycle
• Import and Export database objects
• Test database scripts created in previous versions of Oracle for compatibility with Oracle 10G
• Use Oracle Enterprise Manager to manage database servers
• Perform Backup and Recovery of databases using export/import dumps
• Stress test of Oracle 10G servers by bench marking the loading of hundreds of millions of records

SQL Database Analyst

Confidential

• Provide support for databases currently being used by existing applications: determine database requirements and design databases
• Create Stored Procedures, Write Complex SQL Queries
• Monitor health of SQL Database work closely with Network Administrator, Senior Programmer, Database Administrator: Develop infrastructure for both transactional applications and reporting,
• Develop and maintain a backup and recovery strategy for all databases, assure database backups were successful, SQL maintenance plans are successful and effective
• Performance Tuning of database through creation of clustered and non clustered indexes
• Structure Tables to assure Normalization, Develop Database Maintenance Plans
• Move database objects using Data Transformation Services
• Ensure all databases are properly documented
• Design, create, test and implement SQL stored procedures as necessary to support corporate needs and requirements
• Ensure that modifications to database code will be scalable prior to them being deployed into the production environment
• Manage the security and access rights for all databases
• Develop procedures to continuously monitor database activity to identify and resolve potential performance issues prior to them impacting production applications
• Provide support for implementing database changes required for software releases and production issues
• Make hardware and/or software purchasing recommendations regarding Database Servers
• Backend Development for CRM software Etracker.
• Manage and load all health care related data files into various SQL Databases using DTS packages
• SQL Server Performance Tuning Create necessary indexes to increase performance and speed of data retrieval
• Assist junior analyst and business analyst in writing SQL statements and query optimization
• Create SQL user accounts for various Databases
• Monitor Database Degradation and monitor fragmentation of SQL database
• Design Applications using MS Access, SQL Server
• Ad hoc SQL Reporting for Upper Management
• Data warehousing and Archiving
• GUI Design, Maintenance of Company Internet/Intranet Site
• Application Requirements Gathering interview upper management, to learn departmental needs, workflow, ways to stream line business process, create, design, implement business solutions using all available technology