We provide IT Staff Augmentation Services!

It Security And Risk Team Leader Resume

Corning, NY

OBJECTIVE:

To obtain a Lead Senior Oracle Database Administrator position where many years of in depth technical knowledge and expertise coupled with database security knowledge and expertise can be leveraged as an ongoing contributor and a leader

SUMMARY:

  • Senior Database Administrator with 12+ years of solid experience in all aspects of database administration and engineering for a Confidential 500 company
  • Database security, and IT security and risk assessment expert with Global Security Leadership
  • 24x7 support of over 100 production and more than 350 development OLTP, DSS environments
  • Support for 15 large scale enterprise application projects
  • Strong technical, organizational, analytical, process and people development, and communication skills

SKILLS:

  • Oracle Database 11g
  • Database Security, SANS Network Security
  • Oracle Database 10g, SQL Performance Tuning
  • Oracle Database 10g, Performance Tuning
  • Oracle Database 10g, New Features
  • Oracle Recovery Manager
  • Oracle Database 8i, New Features for Database Administrators
  • PeopleSoft PeopleTools 7.5, 8.5, and 9.1
  • HP Diagnostic Tools, Function Point Counting and Unix Fundamentals

TECHNICAL SKILLS:

Technologies: Oracle RDBMS version 7 to 11g, Oracle RMAN version 9i to 11g, Oracle DataGuard, Oracle Enterprise Manager Grid Control (10g, 11g, 12c), Oracle Optimizer and Tuning Pack, SQLT, TKPROF, Automatic Storage Management (ASM), Cluster Ready Services/Clusterware (CRS), RAC, Oracle Advanced Multi Master Replication, LogMinor, Flashback technology, PL/SQL, SQL Loader, DataPump, Export/Import, lab work with multiple database security software (Oracle Advanced Security, Audit Vault, Database Vault, Data Masking, etc.), GoldenGate, ExaData, SAP, Oracle 12C

Applications and Tools: PeopleSoft Financials, PeopleSoft Human Capital Management (HCM), PeopleSoft Supply Chain (SCM), and PeopleSoft Enterprise Performance Manager (EPM) v. 7.5 to 9.1, eLabor, Remedy, Quest Diagnostics and Expert Tools, data warehouse applications and reporting tools (Cognos, etc.), MS Project, MS Visio, Linux/Unix shell scripting

Platforms: RedHat Linux, MS Windows, Open VMS, Unix T64

Quality: Software/System Development Life Cycle, Function Point Counting, Performance Excellence

PROFESSIONAL EXPERIENCE:

Confidential, Corning, NY

IT Security and Risk Team Leader

Responsibilities:

  • Establishing policies, procedures and standards in all areas of IT with strong focus in database technologies
  • Providing database hardening procedures and guidelines; guiding cross functional global scale projects at all stages, architectures, processes, and vendor engagements
  • Assessing potential risk associated with new and existing global deployments with strong focus in database and application environments, enterprise network security, and wide range of technical and procedural controls
  • Identifying and analyzing gaps related to policy, process, concerning database and application security, and determining severity and potential impact, initiating actions, and providing recommendations based on best practices to minimize risk
  • Initiating and leading vulnerability assessments and penetration testing programs
  • Conducting focused database security awareness across multiple organizational disciplines

Senior Oracle Database Engineer

Confidential

Responsibilities:

  • Primary support for planning, design, development, and deployment phases of large and multi - year projects concerning mission critical enterprise applications such as PeopleSoft HCM, Financials, Supply Chain, and Enterprise Performance Management in clustered environments following SDLC process
  • Leading testing, benchmarking and gathering application requirements to propose design solutions
  • Preparing and executing technical project plan and ensuring successful project deployments and go-lives
  • Providing oversight and direction for continuous performance and capacity management; maintaining database performance by identifying and resolving production and application development problems; calculating optimum values for database parameters
  • Proposal and execution of database security/hardening strategic plan including risk assessment
  • Creating and establishing database security, maintenance and access control standards, procedures and processes related to maintenance of business and projects

Lead Senior Oracle Database Administrator

Confidential

Responsibilities:

  • Supporting large scale mission critical enterprise projects from design to deployment and post go-live
  • Preparing and executing technical project plan and ensuring successful project deployment and go-live
  • Oracle Enterprise Manager Grid Control administration, customization and deployment of performance monitoring and security templates based on database usage
  • Setting up various thresholds, monitoring, auditing and alerting
  • Preparing technical documentations and work instructions and process development
  • Creating database hardening and security standards, procedures and maintenance, evaluation of roles and privileges; creating authorization and access control processes
  • Auditing and ensuring SOX compliancy, and communication with internal and external auditors
  • Interview, selection, and on-boarding and of new resources and junior database administrators f developers and Enterprise Application Support members, and management on application related performance issues
  • Member of SWAT initiatives

Senior Oracle Database Administrator

Confidential

Responsibilities:

  • Key participant and strong contributor to planning, design, development, and deployment stages of 12 large scale mission critical application upgrade projects (PeopleSoft 7.5 to 8.4 to 9.1). Project scope entailed database operating system migration, version upgrade, characters set conversion, PeopleSoft Application and PeopleTools upgrades (contributions are listed at the end of this section)
  • 24x7 operation support for highly available and mission critical, large ERP systems on multi node clusters
  • Database upgrade project leader and hands on database upgrades to 8i, 9i, 10g and 11g
  • Providing system admins with database requirements for new cluster setup
  • Installation and management of ASM, CRS o new clusters
  • Oracle software installation (single instance and RAC), and database creation and maintenance utilizing ASM and NFS file systems on multi node clusters using CRS
  • Set up and maintenance of failover capability for databases (including single instances) utilizing CRS on multi node clusters
  • Database creation, cloning/duplicate, refresh, restore and recovery using RMAN
  • DataGuard setup and configuration, standby database creation and maintenance, and troubleshooting to ensure high availability support as well as testing of disaster recovery procedures
  • Failover and or switchover between standby and primary databases for testing and disaster recovery
  • RMAN setup, backup and recovery, database cloning and duplicate using RMAN or manual
  • Database migration between different operating systems (MS Windows, Unix T64, RedHat Linux) and Oracle versions, and from non ASM to ASM
  • Database performance tuning and optimization such as memory and I/O tuning by analyzing StatsPack, AWR, ADDM, SQL Tuning Advisor, and other Grid Control performance tuning packs
  • Database and application SQL tuning utilizing SQL Trace, TKPROF, SQLT, ASH, etc., and analyzing data to resolve highly challenging performance issues f Oracle Enterprise Manager Grid Control
  • Oracle Enterprise Manager Grid Control Installation, configuration, administration
  • Customization and deployment of performance monitoring and security templates based on the database usage
  • Setting up various thresholds, monitoring, auditing and alerting
  • Using flashback features for data recovery
  • Set up and utilization of LogMinor for audit/forensics and transaction recovery
  • Database patch evaluation, recommendation, deployment and oversight to patch deployments
  • Writing technical documentations, work instructions, and developing database administration process
  • Setup and maintenance of replication
  • First database administrator to create standards for Oracle installations, database creations, OS configurations, and overall database management in Corning Database Administration history
  • Lead database administrator during recovery from a major disaster affecting multiple mission critical environments with zero data loss
  • Outstanding contributions as a key project resource and database administrator related to PeopleSoft Application upgrades included:
  • Gathering requirements and performing analysis, providing input to environment architectural design and determining application environment needs, migration paths and plans
  • Tuning and preparing production databases for go-live by evaluating need for additional storage, database memory or adjustment of initialization parameters for increased throughput and performance during go-live
  • Tuning databases and assisting developers throughout the data conversion process resulting in 80 percent time reduction to complete the process
  • Implementing advanced database administration techniques, developing multi-threaded SQL scripts, and reducing go-live outage duration by 80 percent
  • Developing step by step go-live plan increasing productivity and efficiency, boosting project team/customer confidence, and reducing human errors during go-live executions

Oracle Database Administrator

Confidential, Laurel, MD

Responsibilities:

  • Provided ongoing database administration and application support for multiple large applications.

PeopleSoft Administrator

Confidential, Columbia, MD

Responsibilities:

  • Maintained and supported PeopleSoft HRMS 7.x environments on NT File Servers.

Hire Now