Cobol Administrator
Resume:
Bolivar M Benitez
**** ****** ** ***** ********, GA 30087
************@*****.***
PROFESSIONAL SUMMARY:
•Over 15+ years of Senior Level SQL Server; Oracle Database and Unix administration
•Experience with big data magritaion projects from legacy to MSSQL and Oracle. Designing and creating appropriated documentation.
•Experience functioning as Team Lead/Database Manager for over 15+ years; including managing onshore/offshore resources.
•Experience performing installations, troubleshooting, maintenance on 24X7 on multi-platforms legacy, MSSQL, Oracle, Informix, DB2.
•Software: MSSQL, Oracle, Informix, DB2, ETL, Oracle, TOAD, MSSQL Enterprise Manager, Microfocus COBOL, Life Insurance
EDUCATION:
Bachelor Degree in Computer Science - Baruch College, New York, NY
OCP Oracle University – Atlanta GA.
CERTIFICATIONS:
Oracle 9i/OCP
CompTIA A+
ORACLE DBA 11g
MCDBA 2000 to 2016
CompTIA Security +
Infosys McCamish System Atlanta, GA Jan 4 2018 to Apr 5,2021
Technology Lead / DBA
Installing, Configuring & Upgrading Microsoft SQL Server
Manage 17 MSSQL Migration environments including software Installation, Security, Patches, etc.
Experience with Business Intelligence applications with a strong background in data warehousing
Experience in T- SQL, stored procedures, functions and other DB objects
Design, development, testing, deployment of data warehouse, reporting applications and ETL
Hands-on experience with Microsoft Technology stack such as SQL server 2012/2016, SSIS, SSRS
Experience with designing and developing SSIS packages
Able to design and develop SSRS reports along with modification in existing reports
Expertise in Performance Tuning and Data Cleansing
Good knowledge of Design tools, exposure to Configuration and Release Management methods
Knowledge of Build, Testing, and Maintenance and Support methods and tools
Ability to work in team in diverse/ multiple stakeholder environment
Experience in Life Insurance domain is a plus
Experience and desire to work in a Global delivery environment
Manage a group of 4+ Developers which grow base on project needs
First Data Corporation (Contractor Fintech Consulting) Marietta, GA Aug 2016 / Dec 2017
Sr. Database Administrator
Create data definition, store, organize, and present data.
Administer a variety of database systems Oracle, Microsoft SQL Server.
Participate in the desing and development of database Web services and .Net application for data access.
Technical lead for SQL Server, Oracle and online database projects.
Manage data migration between life cycle environments
Plan and coordinate security measures alongside network administrators.
Create Build and Enhance database designs.
Implementing & Managing Database High Availability
Implementing Effective Backup Strategies For Disaster Recovery
Database Performance Tuning & Query Optimization
Design, develop, and validate reports using SSRS, T-SQL, ETL and SharePoint.
Installing, Configuring & Upgrading Microsoft SQL Server
Architecture and design a migration database from legacy to MSSQL database
Architecture and design a migration database from to MSSQL to File gateway B2B
Create and automate jobs for ETL for various databases. Ability to set up performance monitors and reports.
Design various set of report to help with migration using SSRS
Use SISS utility to create events, task, Data Conversion.
Wincup Stone Mountain, GA Aug 2012 / Sep 2016
Enterprise Database Manage / Sr. Database Administrator
Proactive Maintenance and Monitoring of all instances of MSSQL Server servers
Write custom scripts to automate various daily MSSQL DBA operations
Provide required reports from production environment to other departments on request basis and perform data analysis to provide management with timely and accurate information using SSRS, ETL, Triggers, views, SP, functions.
Performs basic database administration duties such as SQL Server/T-SQL programming, query optimization, SQL Server security, application security, data integrity, performance tuning, maintenance plans and development support for database operations.
Installation and configuration of MSSQL and Oracle environments.
Installed, upgraded and patched database environments as required.
Maintenance and monitoring of different databases (table spaces, data file, control files etc.).
Implement and maintain database security (create and maintain users and roles, assign privileges).
Checking database performance on a regular interval, which includes checking various log files.
Define Backup Strategies and Implementation.
Responsible for the overall performance, tuning, and backup/recovery of all installed databases across all environments
Analyze data models, data relationships, and dependencies
Make report recommendations based on findings.
Mike O’Callaghan Federal Hospital - Nellis Air Force Base N. Las Vegas, NV Jun 2009 / Aug 2012
Sr. SQL Server / Oracle Database Administrator
Sr. MSSQL & Oracle Data Base Administrator
Extensive data migration from legacy to MSSQL and Oracle DB and applications
Database Administration for Microsoft SQL (MSSQL) Server
Troubleshoot and monitoring database related problems
Create and maintain backups, restores, and recovery models in MSSQL
Performance tuning and optimizations using native monitoring and troubleshooting tools
Knowledge of indexes, index management, and statistics
Manage database security features such as: encryption, auditing, and role-based access
Planning, implementing, maintaining, and monitoring transactional replication topologies
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server
Familiarity with Windows Server, HPUX and Linux.
Ability to effectively communicate within a team environment
Installation and configuration of MSSQL and Oracle databases.
Installed, upgraded and patched MSSQL and Oracle software.
Creating clone database for Testing Purpose.
POINT BLANK BODY ARMOR, Pompano Beach, FL Sep 2007 / May 2009
Sr. Oracle Data Base Administrator / MSSQL
Manages and maintains all production and non-production databases 9i, 10g and EPBS 11i (GL, AR, AP, PO, Assets modules)
Responsible for standards and design of physical data storage, maintenance, access and security administration.
Performs backup and recovery on Database Management Systems and configures database parameters.
Optimizes database access and allocates/re-allocates database resources for optimum configuration, database performance and cost.
Responsible for ensuring the performance and reliability of Oracle 11i Version 11.5.5 ESuite Applications (ERP). GL, AR, AP, PO, Cash Management.
Performs troubleshooting for hardware, software and system problems that involve ERP modules. Participates in the projects to implement or enhance ERP systems and applications.
Works with applications administrators in defining user requirements, coordinating system-wide updates and installing upgrades and patches for ERP systems.
Provides recommendations for enhancements/changes that may involve custom design, optional and third party products to improve the efficiency and effectiveness of ERP systems.
Maintains ERP systems security through user profile management creates and updates access permissions and maintains user accounts.
Design and develop data interfaces and conversions
SQL and PL/SQL Programming including stored procedures, functions, packages, database triggers and alerts.
SQL loader and UNIX shell scripts
Creation of customs oracle instances, views, triggers tables and interfaces.
Database Administrator version 9i and 10g, EPBS financial application 11i.
Write scripts and packages to replicate data between inventory and financials applications.
Upgrade and apply patches as need it.
Clone and migrate various databases from Oracle 9i to Oracle 10g (Linux and windows)
Migrate legacy accounting modules AR, AP, PO, GL, assets, Receiving to EPBS 11.5
TRANSOFT Atlanta, GA Jul 2004 / Aug 2007
Senior Oracle & MSSQL DBA
Experience in database designer, database architecture planning, design and implementation support & maintenance for various Oracle HPUX systems.
Installed and updated oracle 8i, 9i, 10g for Windows and HPUX Created shell scripts to automate problem determination and notification Oracle 9i databases, and resolved intermittent database problems.
Refined Oracle replication process that extracted, ASCII data files, remote Oracle databases and pushed the data into a data warehouse.
Created shell scripts to monitor various application processes as well as to Created Oracle 9i databases and resolved intermittent database problems. Reviewed existing databases and made performance tuning recommendations.
Establish, document, and publish hardware and software specifications, standards and configurations to ensure that the technology stack is maintained and leveraged.
Performed analysis, design, coding, and testing of Microfocus COBOL programs and PL/SQL objects. Converted mainframe COBOL programs to Oracle PL/SQL programs.
Experience with Oracle Recovery Manager, UNIX operating systems, database server clustering, and UNIX shell scripting, creating new jobs, scheduling jobs, and setting job notifications/alerts. Installed, upgraded, patched and configured a few RAC Servers, defined storage allocation, flash recovery area, enable archiving and flashback database.
Wrote RMAN scripts to performed Level 0 and Level 1 (Incremental backups) to the flash recovery area and to restore & duplicate databases using RMAN scripts as well. Created the RMAN Catalog and register all databases in it.
Oracle Apps 11i DBA implementing and supporting Oracle Financials Suite (AP AR GL PO) 11.15.10 running on AIX and HP-UX
Identify performance bottleneck on high volume transaction systems. Analyze SQL statements by using explain plan and tkprof, generate Statspack reports and tuned most waited events.
Excellent ability in writing specifications and gathering requirements from the user to develop Crystal Reports as per the needs of the client and maintain documentation of the reports for future reference.
Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
Worked with SQL and PL/SQL, Toad to study the data in different systems and to validate reports, Created Tables, Constraints, Database Triggers, Database Links, Views, Indexes, Synonyms and Sequences using TOAD.
HEWLETT PACKARD Atlanta, GA Jan 2000 / Jun 2004
Sr. Oracle & MSSQL DBA / Programmer - Analyst
Manages and maintains all Microsoft SQL server solutions, including report development and database management.
Maintains reporting solutions and leads new business intelligence projects for data warehousing and reporting.
Facilitates migration projects to transition from legacy line-of-business applications to solutions that deliver more business insight and value.
Monitors and maintains Microsoft Exchange, associated e-mail services, servers, and other devices.
Maintains viable business continuity protocol to ensure data and infrastructure redundancy, integrity, and availability.
Maintains computing environment by identifying network requirements, installing hardware and software upgrades as needed, and monitoring network performance and security, including all requirements to ensure PCI compliance.
Deploys, configures, and maintains the health of various servers and network devices.
Develops, maintains, and executes technology documentation, policies, and procedures.
Conducts auditing for Payment Card Industry (PCI) Data Security Standard (DSS) compliance.
Assists the IS Department with general support, reporting, and other analytical needs.
Flexible schedule and availability to support our systems in a 24/7 environment.
Created Oracle 9I, 10g databases and resolved intermittent database problems. Reviewed existing databases and made performance tuning recommendations.
Converted mainframe COBOL programs to Oracle PL/SQL programs. Refined Oracle replication process that extracted data from remote HP3000 to Oracle databases and pushed the data into a data warehouse. Made performance improvement changes to existing SQL. Migration of various Image DB to Oracle 9i to be use for SAP applications.
Participated in the team than migrate the Supply Chain Management from HP3000 to Oracle 9i & 11i on HP-UX. Refined Oracle replication process that extracted, ASCII data files, remote Oracle databases and pushed the data into a data warehouse.
Identify performance bottleneck on high volume transaction systems. Analyze SQL statements by using explain plan and tkprof, generate Statspack reports and tuned most waited events.
Created Tables, Constraints, Database Triggers, Database Links, Views, Indexes, Synonyms and Sequences using TOAD, Used TOAD extensively to create and modify procedures, packages, tables, indexes etc. Also used for session info, tuning, schema browsing etc.
STARBOARD CRUISE SERVICES. Miami, FL May 1997 / Dec 1999
Oracle MSSQL DBA / Programmer - Analyst
Create and maintain of COBOL, Powerhouse (COGNOS), and Transact HP3000. SQL, SUPRTOOL, Oracle, MPEX, QUERY, VPLUS, Powerhouse (Quick, Quiz, QTP), including extensive JCL, POS System.
Developed on-line programs which reduce process line and save time for the accounting department (GL, AR, Invoicing, Buyers,), act as project leader for the development of various project (Purchase order, Inventory, sales, receiving, Picking & Packing, Delivery tickets, shipping).
Team leader in various project, investigate alternatives to identify/recommend best design; prepare flowcharts, wrote detailed specifications, developed practical solutions to problems, Y2K conversion.
BANK RIO DE LA PLATA. New York, NY Feb 1988 / Apr1997
Junior Programmer
Created or changed programs COBOL S/36 AS400, CICS, JCL.
Responsible of system administration, create and change JCL.
Designed and maintained screen menus programs for all departments as requested.
Maintained and monitored tape drives, back-ups, microcomputers, process.
Assisted senior programmer on projects, design flowchart and write program documentations.
Wrote all JCL from NCR to IBM/36 conversion project.
Contact this candidate