We provide IT Staff Augmentation Services!

Senior Database Solutions Architect Resume

2.00/5 (Submit Your Rating)

Fairfax, VA

SUMMARY

  • Senior Database Solutions Architect wif over 20 years of experience in life - cycle system architecture design and implementation
  • Analyzed system trade-off on cost, scalability, hardware limitations and overall performance matrix
  • Assessed system growth rate and proposed overall capacity planning across multiple platforms including Oracle Supercluster and Oracle Exadata
  • Analyzed software/hardware compatibility and vendor support certifications
  • Conducted technical review on existing systems infrastructure limitations and shortcomings; provide alternative recommendations
  • Managed system implementations and upgrades, providing technical input, strategic planning and best practices
  • Experience wif DISA STIGs requirements for various system implementations including DB, webserver, etc…
  • Provides technical advice to customer on system design and planning for future implementation
  • Experience wif Cloud platform ecosystems for applications and data migrations wif Oracle and PostgreSQL
  • Implemented ORACLE RAC application wif ASM in Oracle 10g, 11g, 12c
  • Setup standby databases via Oracle Data Guard
  • Oracle IDM integrations for various applications single sign-on capabilities wif Oracle Access Manager (OAM), OID, OUD technology stack via SAML2.0
  • Configured logical standby databases through Oracle Data Guard replication for Disaster recovery
  • Managed Oracle Fusion Middleware: OUD, WebCenter, WebLogic, SOA, OATS
  • Implemented BMC Control-M for enterprise level jobs scheduling across multiple platforms/applications
  • Conducted performance tuning by analyzing AWR reports, SQL trace, ASH reports and ADDM, implementing SQL Tunning plan
  • Set up comprehensive backup and recovery procedures wif Oracle RMAN
  • Installed and configured Oracle Enterprise Manager/Cloud Control
  • Conducted overall system failover to stimulate system disaster recovery viability
  • Extensive knowledge in working wif Unix/Linux servers and developing Shell scripts
  • Experience in web-based applications and development in ASP, ASP.Net, Java, and client-server applications in Visual Basic, and C++

PROFESSIONAL EXPERIENCE

Senior Database Solutions Architect

Confidential

Responsibilities:

  • Implemented and sustained all database systems in production, test and development environments wifin the division
  • Extensive implementation of Standby Database via Oracle Dataguard
  • Installed and configured Oracle Restart wif Oracle Grid Infrastructure
  • Performed data integration between Oracle and PostgreSQL databases
  • Provides technical advice to customers on various system enhancement implementations
  • Provides RDBMS knowledge and recommendations to development teams on new requirements and performance tuning
  • Implemented Oracle 13c Cloud Control for system monitoring and management

Senior Oracle Engineer

Confidential

Responsibilities:

  • Designed and built database/middle-tier environments to support the Oracle E-Business Suite (EBS) development effort and production system wif high availability through clustering and Oracle RAC on various platforms
  • Migrated Oracle databases and application stacks to run on Enterprise Cloud platform
  • Implemented OAM, OID to integrate wif Confidential Enterprise idP, AppAuth for Confidential PIV card - Single Sign-on feature for EBS, Sunflower via SAML2.0
  • Configured EBS user access management wif Confidential Enterprise Access Lifecycle Management (ALM) via Sailpoint technology
  • Setup COOP site wif Standby databases using Oracle Data Guard replication
  • Developed end-to-end backup and recovery strategy wif Oracle RMAN wif Oracle Enterprise Manager
  • Implemented and configured Oracle 12c Cloud Control for centralized system monitoring and alerts
  • Implemented BMC Control M for centralized jobs scheduling across various applications/platforms
  • Routine assessment of system growth and capacity planning across enterprise level infrastructure
  • Independent studies on software/hardware requirements to enhance and meet security requirements, overall system efficiencies, performance and life-cycle cost

Senior Solutions Architect

Confidential, VA

Responsibilities:

  • Routine assessment of system growth and capacity planning across enterprise level infrastructure
  • Independent studies on software/hardware requirements to enhance and meet security requirements, overall system efficiencies, performance and life-cycle cost
  • Designed and built database/middle-tier environments to support the Oracle E-Business Suite 12.1 (EBS) development effort and production system wif high availability through clustering and Oracle RAC on various platforms
  • Set up Oracle Data Guard for the COOP site standby database
  • Implemented Confidential CAC card - Single Sign-on feature for EBS, Qlikview, SSRS on Oracle IDM architecture: OAM, OUD, OID, Webgate/Accessgate
  • Implemented BMC Control M for centralized jobs scheduling across various applications/platforms
  • Configured HP Fortify for development code scanning for security risks and IAVA conformity
  • Assess AWS ecosystems for system migrations feasibility and costs analysis
  • Administered various middle tier applications including SOA, Webcenter, Abinitio, Weblogic and Microsoft SQL Server
  • Implemented and configured Oracle 12c Cloud Control for centralized system monitoring and alerts
  • Cloned Oracle EBS environments using Rapid Clone utility
  • Developed end-to-end backup and recovery strategy wif Oracle RMAN and NetVault Backup solution
  • Confidential STIG implementation on the DBMS
  • Performance tuning on PL/SQL packages for external data load and data conversion
  • Deployment and maintenance support for Qlikview dashboard and SSRS reports

Senior Database Administrator

Confidential, Fairfax, VA

Responsibilities:

  • Designed new system infrastructures to modernize the legacy systems
  • Implemented a large database environment wif more than 6 TB of data on Oracle 11gR2 supporting a 24/7 web-based application in a secured Cloud environment
  • Designed and implemented the architecture of the Secure Cloud system framework
  • Developed backup and recovery procedures wif Oracle RMAN and EMC Data Domain Boost
  • Implemented extensive Oracle Text indexing wifin the application for text-based searches
  • Developed system level security configurations to meet the strict federal level security requirements
  • Implemented advanced compression for BLOB data type to reduce storage requirement
  • Provided recommendations and technical inputs to development and technical support team on troubleshooting and performance tuning
  • Analyzed existing system architecture to find enhancement opportunities through the review of AWR reports, SQL trace, ASH, and ADDM
  • Provided system hardware design and capacity planning for RDBMS system implementation and migration projects
  • Conducted performance tuning through SQL tuning and system level resource configurations

Senior Database Administrator

Confidential, Dulles, VA

Responsibilities:

  • Routine on-site visits to various federal agencies
  • Provided recommendations and technical inputs to client application owners on project plans and system health check
  • Worked wif security officials on system level security audits, adhering to Confidential STIG standards
  • Worked closely wif client IT personnel to coordinate implementation projects and maintenance tasks
  • Performed system hardware design and capacity planning for new application implementation and expansion
  • Performed SQL tuning and system level resource configurations

Lead Database Administrator

Confidential, Woodbridge, VA

Responsibilities:

  • Led system hardware design and capacity planning for new applications
  • Managed the billing system which required 99.9% of up time wif fail-over capability
  • Managed Oracle Enterprise Edition database management system for Oracle PeopleSoft, Harris Computer’s Cayenta, Hansen, ESRI GIS and SCADA system
  • Implemented Oracle ASM database storage architecture on NetApp SAN units
  • Monitored application database performance based on SGA, me/O, Global cache through Oracle EM
  • Set up and manage automated system alerts on performance metrics wif Oracle EM
  • Responsible for routine performance tuning through memory tuning, schema tuning, and SQL tuning
  • Managed platform migration projects, migrating legacy systems to newer server platforms: Windows to Unix or Linux, etc.
  • Responsible for database upgrades: Upgraded from 9i to 10g, will upgrade from 10g to 11g
  • Performed annual disaster recovery exercises, recovering all critical database systems to full capacity from the designated remote site
  • Managed ETL projects, generate text-based data files for bulk data load through SQL Loader
  • Performed data modeling and construct architectural designs through forward/reverse engineering, as well as synchronizing databases wif data models using CA Erwin software
  • Provided daily application support; working closely wif end users and system developers to troubleshoot system problems and implementing enhancements and changes as required
  • Developed custom routine processes to extract data from the database to be transferred to third-party consultants

Database Administrator

Confidential, Alexandria, VA

Responsibilities:

  • Administered backup processes, including implementation of a cron job utilizing Korn Shell Scripting, Oracle Recovery Manager (RMAN) and Oracle Import/Export utility
  • Set up Oracle Data Guard to enhance database recovery and minimize downtime
  • Monitored database performance based on SGA, data files and schema statistics
  • Developed complex PL/SQL procedures, triggers, functions and packages to fulfill business rules and requirements
  • Performed database migration/upgrade from Oracle version 8i to 9i and 9i to 10g
  • Managed data migration from FoxPro, MS Access, SQL* Server database systems to Oracle: developed PL/SQL procedures for data mapping, conversion and parsing
  • Obtained extensive experience in FIPS 140-2 compliance data encryptions including Secure FTP and IPSEC
  • Designed, developed and implemented a stored-forward casualty reporting application in Visual Basic 6.0 enabling temporary storage of information locally and automatic transmission of information to the central repository via email. Implemented worldwide wif 5,000+ users
  • Developed a web-based status tracking tool using ASP.net to allow senior management to query the status of casualty cases received from U.S. bases worldwide
  • Managed Internet Information Server by applying security updates and patches
  • Created and administered test environments for Power Builder and Web-based applications by generating self - running scripts to simulate real usage for stress/load testing

We'd love your feedback!