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