SUMMARY:

• A technically minded and multi - disciplined Engineer with over 9 years of experience in the IT field and 6 years as an Oracle DBA. Detail-oriented with the ability to provide exceptional value throughout system development Life cycle. Extensive experience including but not limited to Backup and Recovery, Data Redaction, Application Express, Database Security, Memory Management, performance tuning using OEM and Upgrades on a variety of platforms like UNIX (Solaris and AIX) and Linux 7.
• Over 6+ years of experience as an Oracle Certified Database Administrator, providing 24X7 production and development support 11g/10g databases on platforms like AIX and RedHat Linux.
• Performed data-pump upgrade databases from 11.2.0.4 to 12.2.0.1
• Decommission Legacy Databases and it’s associated files.
• Proficient in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning, space management, database security, physical and logical database design and documentation.
• Perform Database capacity planning as well as tablespace capacity planning.
• Managed, Supported, Upgraded and Patched APPLICATION EXPRESS
• Manage Database Listener which involves start, stop and checking status (lsnrctl start, stop, status)
• Regularly check level of compression and compress tables to reduce disk space.
• Clone databases across multiple servers from production to non-production environment
• Rebuild indexes and add or rename, resize data files in table spaces.
• Assist with Oracle Linux non-production and production Server Maintenance.
• Experience with databases running on Windows / UNIX (AIX) /Linux (RedHat).
• Performe backups and tested crash recoveries using conventional hot & cold backups and RMAN, cloning databases using RMAN.
• Assisted in the implementation of High Availability solutions with Oracle 11g RAC. Strong knowledge in disaster recovery failover/switchover procedure. Oracle data-guard hands-on support.
• Install and patch databases on a quaterly basis as well as update Opatch Installer.
• Experience in installation, configuration and administration of Oracle Databases.
• Awareness on Oracle Support processes for technical requests through Meta link (MOS).
• Expertise in RDBMS Tools like Toad, Import/Export, Data Pump, RMAN, OEM Grid Control.
• Experience working in a highly available, mission critical 24X7 production database environment.
• Worked on Oracle 11g, and 10g versions handling support, installation, configuration, upgrades, migration, backup and recovery, performance tuning, cloning, space management and security.
• Adept at routine Database Administration tasks including automated installation, management of table-spaces, logs, grants, roles, users, indexes and security.
• Rebuild standby databases as well as apply archive-logs on databases out of sync.
• Managed Golden Gate from Extraction in production to Data-pump and Replicating in development
• Configure Oracle 11g/12c OEM Grid Control to monitor database. And also added targets to OEM.
• Excellent interpersonal skills and analytical skills.

TECHNICAL SKILLS:

Operating Systems: Linux Enterprise Server 7, Windows XP, and UNIX (Solaris and AIX).

RDBMS: Oracle 11g/12c.

Languages: SQL, light PL/SQL knowledge and Basic shell scripting.

Supported: Application Express.

Tools: Data Pump, DBCA, DBUA, RMAN, OEM, AWR, and ADDM, Toad, Team Viewer, Cisco VPN Client, Moba-Xterm, SCSM and Remedy Ticketing Tool, VMware Horizon Client, Cisco Jabber phone, Skype For Business, ADDM, TOAD, Winscp, Cygwin and Notepad ++

PROFESSIONAL EXPERIENCE:

Confidential, Sidney, NE

DB2 Database Administrator

• DB2 Training for Confidential while still supporting Cabela’s Inc. as an Oracle DBA.

Confidential, Sidney, NE

Oracle Database Administrator

• Cabela’s is a $4.1 Billion originally owned family retailer of hunting, fishing, boating, camping, and related outdoor recreation merchandise.
• Oracle DBA Queue Manager as well as Support Application Express.
• Support Development Teams by implementing database objects in TEST/STG/UAT/PROD and through on call rotation.
• Managing database backup and recovery. Determine requirements, and then set up, schedule, and monitor backup processes. Recover databases as needed.
• Performed health checks and proactive monitoring using Oracle Enterprise Manager/Grid Control and UNIX shell scripts.
• Add databases and servers in OEM and set database monitoring alerts.
• Performed Data Redaction in Oracle DB 12.1.0.2 and Data Masking on PCI and PII information
• Regularly performed database object level recovery even if they are not backed up.
• Upgrading Oracle 11g to 12c multitenant Container and deleting legacy databases.
• Managing database growth, data purging/archiving. Monitor storage use and work with application team to set up purge/archive processes.
• Database monitoring, tuning, and troubleshooting. Create, setup, and respond to alerts. Analyze performance data and recommend solutions.
• Managing database security, roles, and profiles. Set up users and assign appropriate privileges.
• Check data guard standby Apply to make sure primary databases are in sync with standby databases
• Manage Application Express: Creating Apps, creating users, importing and exporting Apps etc.
• Defining and implementing physical database layout. Work with the application team to understand the application's data, and then determine the appropriate physical structure. Participate in application design and development. Attend design meetings and reviews.
• Problem prevention, detection, and correction. Analyze performance data, errors, and alerts, looking for areas where problems may occur. React and fix problems when they do occur.
• Communicating with RDBMS vendors, users, and management. Work with vendors to stay current on their technology products and assess and recommend products that can benefit Cabela's.
• SCSM Ticket Queue Lead. Manage the queue on clearing Service Requests (SR), Incident Request (IR), Change Request (CR) and Manual Activities (MA).
• Data-Guard. Check standby apply every morning to make sure standby databases are in sync with primary databases. Then apply redo-logs as needed to recover standby databases.
• Basic scripting. Write scripts for data-pump jobs, backup and recover and database checks.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and set up Rules for alert notification and schedule RMAN backups with Failure notification.
• Exposure to Database FIREWALL and Audit Vault. Managed a Three-Node RAC Cluster.
• Schedule the Physical backups (hot & cold) in CRON tab using RMAN and monitor scheduled jobs.

Confidential, Houston, TX

SCRUM MASTER

Responsibilities:

• Organize and facilitate team backlog management, daily stand-up meetings, reviews, retrospectives and other Scrum-related rituals
• Share agile knowledge and best practices across the organization to maximize scrum team performance and effectiveness.
• Assist Product Owner with backlog maintenance and communication to improve transparency.
• Coach teams, individuals and the organization in collaboration, transparency and iteration.
• Build consensus through collaboration and has the ability to influence without authority
• Provide performance feedback and complete performance evaluations for team members
• Ability to effectively communicate program management plans, proposals, and results, and negotiate options at business unit levels

Confidential, Charlotte, NC

Database Analyst

Responsibilities:

• 24x7 production database administration and supported On-Call during off hours.
• Register and unregister databases in the recovery catalog.
• Day-to-day tasks such as created and modified database objects like tables, Indexes, Views, Sequences, Functions, Procedures, Triggers and Packages. In addition, assigning roles and privileges to users and providing security for the databases.
• Managed Oracle 11g to 12c multitenant Container and deleting legacy databases.
• Performed regular server health checkup to make sure database health is not affected (df-k) command. Monitor storage use and work with application team to add more data-files as needed.
• Database monitoring, tuning, and troubleshooting and respond to alerts.
• Supported Development Teams by implementing database objects, tables, indexes etc. in DEV/TEST/PROD and through on call rotation.
• Managed database security and roles. Set up users, roles and assign appropriate privileges to each.
• Supported, monitor & tune the database instances, which includes starting and stopping instances.
• Scheduled Physical backups (hot/cold) using RMAN utility and monitoring scheduled jobs.
• Performed database Backup, Restore and Recovery.
• Installed and configured oracle database on Linux platforms.
• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and set up Rules for alert notification and schedule RMAN backups with Failure notification.
• Manage /etc/oratab adding and removing database entries.
• Manage snap shot too old (ORA01555) to read consistency issues.
• Extensively used AWR, ADDM and explain plan for periodic performance tuning.

Environment: and Tools: Development, Test, and Production, oracle 12c/11g, SCSM Ticketing Tool, Red Hat Linux 7, RMAN, Data-pump, OEM cloud control12c, TOAD, MobaXterm, DBCA, AWR, and ADDM, Toad, Cisco VPN Client, Moba-Xterm, SQL Developer, Putty and EXPLAIN PLAN .

Confidential, Charlotte, NC

IT Analyst - Financial Crimes

Responsibilities:

• Assisted the project manager in the creation of the project charter & vision document during the inception phase of the project.
• Developed a work plan detailing the tasks and effort required to achieve the scope of the project.
• Researched and analyzed data such as customer design proposal and specifications to determine feasibility of design, Cost evaluation and assist in product design.
• Led reporting and analysis of SOP processes, including service levels, inventory levels, IT capacity planning and forecasting
• Provided training for existing applications, tools and procedures; acted as SME and IT resource for the engineers and administrative staff.
• Applied project management knowledge and expertise to gauge system performance and assess risk
• Facilitated and conducted technical/non-technical presentations to training workshops for the clients.

Confidential, Concord, NC

IT Service Desk Analyst

Responsibilities:

• Outbound or Inbound service calls to resolve customers' problems and inquires, including but not limited to tech support and account information.
• Usage of active directory and sales force to complete daily work.
• Required to use and refer to internal ticketing system when customer calls or when issue arises.
• Ensured to compute all relevant information into customers account for future referencing.
• Answered user inquiries regarding computer, email, phone connectivity, software or hardware inquires to router configurations.
• Assisted clients with lockouts or password changes with an internal system
• Maintained records of every of communication transaction in call tracking system, problems and remedial actions taken, and next steps and contacts to resolution
• Handle anywhere between 40- 50 Tickets on a daily average.