We provide IT Staff Augmentation Services!

Senior Security Database Administrator And Project Lead Resume

5.00/5 (Submit Your Rating)

Atlanta, GA

TECHNICAL SKILLS:

Databases: Oracle 12c, Oracle 11gR2 through Oracle 8, SQL Server 2008, 2005, 2000 and 7, Sybase System 11 and Teradata

Database Utilities/Tools: Oracle Key Vault, Oracle Goldengate, Oracle Dataguard, Oracle Datapump, SQLLoader, Oracle Cloud Control, Oracle Grid Control, SQL Server Integration Server, SQL Server Analysis Server, SQL Server Report Server, Oracle SQL Developer, Toad

Operating Systems: Linux, Sun Solaris, Solaris Express, HPUX, AIX, SCO UNIX, and Windows XP/2000/NT/2003

Hardware: Oracle SuperCluster Engineered Systems, Oracle Exadata Engineered Systems, Oracle Database Appliance, Oracle RAC, various HP, SUN and IBM servers, Windows Server Platforms and EMC and 3Par SAN storage

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Senior Security Database Administrator and Project Lead

Responsibilities:

  • Design, coordinate and implement enterprise - wide Oracle Client upgrade for user and server enviroments
  • Implement Oracle Transparent Data Encryption on key financial applications to meet the project schedule and company security requirements.
  • Install, upgrade and maintain Oracle Key Vault software on all production, disaster recovery and testing environments
  • Write automation shell scripts for Oracle Key Vault database and system storage management and monitoring
  • Migrate Transparent Data Encryption local wallets to Oracle Key Vault
  • Evaluate security software policies and procedures
  • Design and conduct security training including hands on lab exercises

Utilized: Oracle 12c, Oralce11gR2, Oracle Exadata, Oracle RAC, Oracle Key Vault, Goldengate, DataGuard, Oracle Grid Control and Cloud Control, Veritas Cluster Services, Toad, ASM storage, RMAN, Oracle utilities, Linux shell scripting

Confidential, Alpharetta, GA

Platform Engineer Database Administrator/ /Permanent

Responsibilities:

  • Installed, configured and maintained Oracle Goldengate (Oracle to Oracle) data replication.
  • Performed Oracle database server migrations, upgrades, security patching to maintain corporate data security compliance and stability.
  • Created, implemented and maintained shell scripts to monitor and perform database maintenance in all Oracle environments (Oracle 10G to 12c)
  • Implemented and evaluated Oracle Transparent Data Encryption (TDE) using local and HSM datastores
  • Performed RMAN backup and recovery testing
  • Conducted peer mentoring and training sessions

Utilized: Oracle 12c, Oralce11gR2, Oracle 10G, Oracle Exadata, Oracle Database Appliance (ODA), Oracle RAC, Goldengate, DataGuard, Oracle Grid Control and Cloud Control, Toad, ASM storage, RMAN, Oracle utilities, Linux shell scripting

Confidential, Johns Creek, GA

Senior Database Administrator/ Permanent

Responsibilities:

  • Installed, configured and maintained data replication via Oracle Goldengate (Oracle to Oracle, DB2 to Oracle and SQL Server to Oracle).
  • Technical lead for Delphix data replication project which resulted in 95% reduction in data refresh and up to 95 percent reduction in disk consumption.
  • Performed Oracle database server migrations, upgrades, security patches and bug fix to maintain corporate data compliance and stability.
  • Mentored and trained new hires and junior team members.
  • Performed advanced database performance tuning

Utilized: Oralce11gR2, Oracle 10G, Oracle Exadata, Oracle Supercluster, Oracle RAC, Delphix Data Replication, Goldengate, Dataguard, Oracle Grid Control and Cloud Control, Toad, ASM storage, RMAN, Oracle utilities, SQL Server Replication, UNIX shell scripting

Confidential, Atlanta, GA

Senior/Lead Database Administrator/ Permanent

Responsibilities:

  • Tuned Oracle databases to reduce response time by 70 percent for complex queries.
  • Developed Oracle and SQL Server database disaster recovery procedures to meet 99.9% database uptime.
  • Configured and maintained physical Dataguard replication of production databases up to 4 terabytes in size.
  • Created and cloned Oracle and SQL Server schemas and databases to support development and quality assurance testing environments.
  • Managed logical and physical layout for Oracle and SQL Server database utilizing SAN storage and virtual server environment.
  • Automated and optimized scheduled database refresh, data loads and backups to support SDLC projects
  • Upgraded and patched and SQL Server databases.

Utilized: Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i, SQL Server 2005, SQL Server 2000, SSAS, SSIS, SSRS, SQLPlus, Oracle table/index partitioning, import, export, SQLLoader, DataGuard, Toad, OEM and Grid Control, SQL Server Management Studio and Windows Scheduled Tasks, RMAN, VBscript, VMware

Confidential, Atlanta, GA

Oracle DBA / Teradata Database Analyst / Consultant

Responsibilities:

  • Created and maintained Oracle data repository to containing marketing and customer data.
  • Wrote UNIX shell scripts for data load and retrieval automation.
  • Gathered and analyzed customer data stored in several Teradata database.
  • Loaded and maintained key Teradata data warehouse of over 20 million rows production revenue data monthly.
  • Enforced space management on Teradata server.

Utilized: Oracle 9.2.0, Oracle export/import, SQLPlus, PL/SQL, NET8, SQLLoader, Oracle Enterprise Manager, UNIX shell scripting, TCP/IP, IBM servers, Windows 2000/NT, Teradata fastload, Teradata fastexport, Teradata bteq, Teradata scripting, Queryman

Confidential, Stone Mountain, GA

Data Migration Project Consultant

Responsibilities:

  • Managed full life cycle of the project to upgrade to a Windows 2000 network infrastructure to enhance data accessibility with 2 other local medical centers.
  • Interacted with all project vendors to successfully coordinate software application upgrades and installations to ensure system compliance.
  • Created and implemented project plans, timelines and test plans.
  • Developed backup and recovery procedures and system and user security standards.

Utilized: Dell 9000 servers, Windows XP, Windows 2000 server, Cisco routers, Dell network switches, 4 Dell Windows 2000 servers, Active Directory, Adaptive Server, RAID array, Terminal Server, Veritas Backup Exec, remote AS400 interface, Crystal Reports, TCP/IP, network configuration, remote client access.

Confidential, Atlanta, GA

Senior Oracle DBA/Consultant

Responsibilities:

  • Performed advance SQL query tuning in Oracle8i data warehouse environments on a rapidly growing AIX platform.
  • Responsible for maintaining data integrity, security, rapid updates and queries of sensitive patient medical records.
  • Created triggers, stored procedures, materialized views for enhanced remote data replication and synchronization.
  • Created new instances and refreshed data to support development efforts.
  • Maintained database security via unique database roles and object permissions.

Utilized: Oracle 9i, Oracle 8i, Oracle export/import, SQLPlus, PL/SQL, NET8, SQLLoader, Universal installer, Oracle Intermedia server, Oracle Enterprise Manager, Oracle Java functions, Oracle Trace, RMAN, Top Session, Oracle table/index partitioning, UNIX shell scripting, TCP/IP, IBM servers, AIX, Windows 2000/NT

Confidential, Atlanta, GA

Lead Oracle DBA/Consultant

Responsibilities:

  • Performed data database upgrade, migration and consolidation of corporate legal production data interfacing with SQL Server database.
  • Managed 12 production and development Oracle 8 and 8i databases on UNIX and NT platforms.
  • Evaluated software compliance of Oracle 9i with existing and proposed hardware and application software for HR department.
  • Performed software installation, upgrades, performance monitoring and tuning on UNIX and NT servers.
  • Designed and performed Oracle backup and recovery procedures for 12 databases.

Utilized: Oracle 9i, Oracle 8i, Oracle 8, Oracle 7.3.4, Oracle 7.3.2, SQL Server 7, SQLPlus, PL/SQL, Net8, Oracle Enterprise Manager, import/export, PL/SQL programming, ODBC, stored procedures, HPUX, Windows NT server and client, UNIX shell scripting, Crystal Report Writing, Business Objects, Veritas Backup Exec, RAID array, TCP/IP, Terminal Server

Confidential, Atlanta, GA

Senior Oracle DBA/Consultant

Responsibilities:

  • Designed and implemented production migration procedures and application testing procedures. Instrumental in successfully achieving year-end project deadlines.
  • Maintained database security utilizing database roles and object permissions.
  • Performed performance tuning and capacity monitoring to troubleshoot performance issues.
  • Backed up and recovered production data to refresh development databases daily.
  • Performed system administration duties including creation of raw partitions, allocation of logical devices, physical disk space management and capacity planning.

Unitized: Oracle 8i, Oracle 8, ODBC, Oracle Apps 11, PeopleSoft HR, Oracle Application Server, Oracle Installer, Oracle Financials, Oracle export/import, Oracle backup and recovery, SQLLoader, SQL Trace, PL/SQL, SQLPlus, Server Manager, Sun Solaris, Sun raw disk partition management, Windows NT client/server, Windows 2000, UNIX shell scripting, RAID array

Confidential, Atlanta, GA

Senior Oracle DBA/Consultant

Responsibilities:

  • Performed logical and physical design and database implementation to support a fast paced Internet marketing company receiving millions of product registrations daily.
  • Developed and documented database standards to utilize in the development environment and migrate to the production environments.
  • Performed storage capacity planning for production environments with estimates for future growth exceeding 1 terabyte.
  • Developed migration plans to upgrade from MTI storage arrays to EMC storage arrays.
  • Performed database installation, upgrade and tuning upgrading Oracle8 to Oracle8i on SUN and NT platforms.
  • Performed advance database performance tuning …

Utilized: Oracle 8i, Oracle 8, export/import, SQLLoader, PL/SQL, SQL Trace, Oracle Installer, Oracle Enterprise Manager, Oracle stored procedures, UNIX shell scripting, Crystal Reports, Sun servers, Solaris, EMC array storage, MTI Storage array, Windows NT

Confidential, Atlanta, GA

Lead Oracle DBA / Consultant

Responsibilities:

  • Supported production data warehouse environment responsible for daily, weekly and monthly data loads between remote Teradata and Oracle databases and 7 production Oracle instances using SQLLoader.
  • Migrated production data from several Oracle instances to a 3-terabyte Sun server.
  • Established production databases and operating system standards, capacity plans on EMC storage structures, and upgrading the database from Oracle 7.3.3 to Oracle 8.0.5.
  • Performed performance tuning related to Oracle8.
  • Developed large-scale backup and emergency recover procedure of the databases.
  • Enhanced UNIX shell scripting for performance monitoring and SQLLoader process automation.

Utilized: Oracle 8, Oracle 7.3x, PL/SQL, SQLLoader, import/export, Oracle triggers, Oracle snapshots, SQL Trace, Oracle Optimizer usage, Teradata database interface, Sun Solaris, Sun 10k server, EMC storage arrays, MS Project, Windows NT/98, UNIX shell scripting

We'd love your feedback!