PROFESSIONAL SUMMARY

• 14 years in Enterprise Architecture, Design, Data modeling, Database Reengineering, Systems Admin including Applications Development Life Cycle (SDLC), and Management.15 years of experience as an Oracle Architect/DBA (Version 7/8/9/10G/11G/11.5ERPOracle Database Administrator Certified Professional
• 10 years as MS SQL Server Database Architect/Administrator (7.0/2000/2005/2008)Microsoft SQL Server Certified Professional, SQL Analysis Services, SQL Reporting Services
• 8 years detailed experience as a Leader in SAP R/3 4.6C/4.7/6.0 Enterprise Basis Systems & Security administrator, support background, ECC 6.0 Unicode upgrade, SAP transport management, migration, integration, and master data management.
• 7 years working with MYSQL database architecture and design including Database administration functions like installation, configuration, clustering, troubleshooting, replication, backup/recovery, performance tuning, monitoring, production planning, development, security, etc.
• Strong technical skills with Leadership abilities, excellent team management, vendor management, communications skills and perform well under pressure.

TECHNICAL SKILLS

Programming Languages: PL/SQL, Oracle SQL, SQL Plus, SQL Loader, SQL Developer, K - Shell script, Perl, Bash, TSQL, HTML, Assembler, Visual Fox pro, PL/I, IBM 370 Assembler, Dbase2, C/C++, Cobol, JavaScript, Java Applets, VBScript, Visual Basic, and Basic

Software/Databases: Oracle 7/8//9/10G/11G, PeopleSoft HCM 9.1, Oracle RAC, MYSQL Server, EPIC, Oracle Application Server 11iAS, Oracle Application Suite (Order management, purchasing, General ledger, Order-to-cash, Inventory), Oracle Express, Oracle E-Business suite 11i (Oracle Discoverer, Concurrent manager, Portal), Oracle RDBMS, Microsoft SQL Server 7.0,2000,2005,2008, Sybase, Teradata, Oracle Data Warehouse, IMS, IDMS, SQLBASE, Borland Delphi 4, LIMS (Laboratory Information Management System), SAP ERP R/3 4.6c (System application & product), Prism/EPRISM, SAP ERP/Basis, Informix, NetApp, VERITAS Netbackup/Volume Manager, ESRI's Spatial Data Engine (ArchSDE), ESRI ArcGIS Server, ArcObjects, SAN, NAS, LDAP, WebSphere Process Server (WPS), WebSphere Application Server (WAS), WebSphere MQ, EMC Symmetrix, Golden-Gate (replication).

Operating Systems/Network: Microsoft Windows 2000/2003/2008 Server, Microsoft Windows NT, Sun Solaris 10, AIX, Linux (Red-hat 5.3), Linux (Suse), Microsoft Windows XP, HP-Unix/Unix shell scripts, AS/400, Net-BIOS, TCP/IP, DOS, Sybase System, Smart System, MVS/OS, Alpha/Vax VMS, DCL, OS/2, IBM LAN Server, Ethernet, Token ring, Tomcat, Servlets, VMware ESX3.0, Novell network, Formal BMC/Remedy AR System Administration training, ITIL, BMC IT Service Management 7.5, BPM

Analysis Methods & BI Tools: Business Objects XIR3 Enterprise 6.5 (Universe development, Xcelsius, report analytic Web Intelligence, Universes, development, dash boarding, BO Configuration and Admin functions), Web Intelligence, Dashboard Manager, Toad, Autosys (job scheduling), Power Designer, Qdesigner, Erwin (Database management tool), OEM, Eclipse, ER/Studio, Primavera, XML, Microsoft Exchange Server, CA Model Manager, SQL Navigator, Precise SQL, J2EE, WebLogic, .NET, LDAP, Oracle, SOA Software, UML, MS Web Development, Lotus Domino Web Development, Web-sphere, SQLab Xpert, Netscape proxy server, Apache server, J2EE, Microsoft Visual C++, Object oriented design, Relational Database Design, Mercury, Voyager, Top end, Tuxedo, Rational SQA, Visual Basic Editor, Data Views, IBM Communications manager/2, IBM Netfinity Manager, Programmer 2000, Designer 2000, Developer 2000, CICS, JCL, Lotus Notes V4.6, 5.0, 6.1/scripts, Crystal reports, Microsoft Office2000 Suite, VSAM file processing, IBM LAN Management Utilities/2, ODBC (Open Database connectivity), DAO, ADO (ActiveX Data Objects), OOD/OOP (Attributes - Object Oriented Design), Wise Scripting, Install Shield Scripting, Quick Test tools, VB Script, RUP(Rational Unified Process), Clear-case, subversion, ETL Extract Transform Load ( Informatica 8.1, Data Stage, rational rose, Clear-quest, Erwin, Enterprise Architect), Agile methodology, SOA, SMS (Systems management Server), Subversion (configuration management), Hyperion, MicroStrategy.

PROFESSIONAL EXPERIENCE

Confidential St. Louis, MO

Sr. Enterprise Architect

Responsibilities:

• Works closely with Software Development teams and the IT Operations team to assist in the design and implementation of scalable Database Solutions based upon Oracle, MYSQL, and SQL Server for an aggressively growing billing and back office BOSS system utilized for internal operations as well as external clients.
• Manages two teams: Database / Solution Architects and Database Administrators.
• Provides recommendations and assistance regarding Oracle/SQL Server/MYSQL database architecture and roadmaps, database standards, performance and scalability improvements
• Participate as a Member of the Senior Architecture team in governance processes of the organization's architecture and applications.
• Creates the solution architectures and shepherding them through the various architecture governance processes to ensure they are aligned with the strategic direction, utilizing approved technology standards, and following the appropriate guiding principles.
• Provides technical leadership to Software engineering and participates in the technology evaluation, test and integration of new platforms and software in partnership with the technology team.
• Advocates best practices for documentation of data, quality improvement/assessment activities, database monitoring, and schema development.
• Researches, analyzes, determines capabilities and proposes technology solution alternatives that address specific business needs and product/service strategies across Lines of Business
• Serves as the industry and technology expert, providing application strategy oversight and planning for enterprise architecture technology functions
• Assists IT investment planning, architecture governance and partner management
• Demonstrates strong technical knowledge of application delivery methods and familiarity with how portfolios of systems working together to create enterprise solutions
• Establishes and maintains a high level of trust, confidence and intellectual integrity with both Business and IT partners
• Lead other Project teams in Database platform design on Oracle 10G/11G, SQL Server 2008, MYSQL 5.0, including implementation, performance monitoring, and tuning.
• Conducts business analysis, event modeling, logical and physical database design, database optimization, load strategy design and implementation, security and change management.
• Oversees the direction and support of enterprise tools needed to support the development and QA processes.
• Work with each Line of business to ensure the successful adoption and use of enterprise application technologies. This includes conformance to the strategies, reference architectures, and guiding principles.
• Directs the Enterprise systems development process, including planning and monitoring development efforts, reviewing deliverables, and communications to management.
• Partners with customers to capture and analyze business needs and information requirements, define optimum system requirements to meet business needs, and prioritize and manage new requirements.
• Building and leading a team of technical partners responsible for the engineering, performance, availability and administration of the OSS and BOSS server systems in the Clearwire production network.
• Performs database schema development, reverse engineering, documentation, implementation and maintenance, including monitoring and improvements.
• Designs Enterprise database availability though Oracle High Availability architecture utilizing Real Application Clusters (RAC) and Data Guard on Linux 5.3 platform (Suse/Redhat)
• Advocates best practices for documentation of data, quality improvement/assessment activities, database monitoring, and schema development.
• Designs and implements core Database Architecture strategies such as replication, failover, clustering, data partitioning, and archiving on Linux 5.3 platform (Suse/Redhat)
• Coordinates work-effort across projects and business areas and provides quality information for Schema development and implementation.
• Ensures the scalability and flexibility of underlying data models and the architecture on Databases
• Develops conceptual, logical, and physical data models in support of an Oracle data warehouse system
• Coordinates with the business community and application development to analyze business requirements and develop information models, diagrams and reports that contribute to the data architecture
• Maintains the documentation of all components of the data architecture (conceptual, logical and physical models) through a central data repository
• Development and deployment of policies and procedures on data-related activities such as data integrity, data quality, data security, data inventory, data standards, data sharing and data repository
• Manages the Enterprise database projects through various teams to ensure adequate capacity is deployed and available in the network to ensure systems provide excellent service to Clearwire customers
• Defines and documents global Enterprise OSS/BOSS Database development and implementation standards for software teams to follow and working with data models.
• Assesses and build teams, define roles and responsibilities, influence and shape outlook and attitudes
• Collaborates with management, staff and clients on technology strategy, enterprise architecture and critical investments in strategic technology
• Evaluates organizational structure and determine competency gaps, core strengths and plan for optimization and/or augmentation
• Oversees the creation of the solution architectures within the Global Architecture group to support the enterprise strategic initiatives along with the Line of business initiatives.
• Optimizes performance for large databases with real time constraints in mission critical systems with 10s of thousands of concurrent users

Confidential, Lake St. Louis, MO

Enterprise Architect

Responsibilities:

• Administering, installed, configured, Oracle 9i/10G/11G Databases and resolving application issues.
• Performed all the backup/recovery using RMAN and cloning on Linux 5.3 (Suse/redhat) platform.
• Determined user access and assists with security procedures and capacity planning.
• Created a work environment where partners were challenged to work at high performance levels; set high expectations for partners and developed a highly efficient team.
• Reviewed standard policies for Corporate security, evaluating security within Oracle 10G/11G
• Supported, designed, and developed custom add-ons to the Oracle databases.
• Provided physical and logical database design using Erwin for OLTP on Linux 5.3(redhat) Platform
• Forecasted capacity requirements, including budget and schedules, space, power etc. required to maintain adequate network performance
• Building and leading a team of technical partners responsible for the engineering, performance, availability and administration of the server systems in the NISC production network.
• Created and managed a team of partners who were responsible for engineering design, performance and administration of server systems and applications.
• Monitored adherence of teams to given direction, and reporting the status to upper management.
• Used Erwin to create and maintain Databases, Data warehouse and enterprise Data Models.
• Performed basic database functions and fundamental data modeling tasks including constraint design attribute definition, E/R modeling, and Designer/Developer 2000.
• Performed problem diagnosis, capacity planning, configuration management, and performance tuning and bottle neck analysis using AWR, ADDM, Oracle 10G/11G wait events, and TKPROF.
• Managed teams to perform design reviews, integration testing and implementation in conjunction with technology teams. Established KPIs during design phase; ensured test plans were adequate to verify KPIs can be met with new systems
• Upgraded all the Oracle 9i Database environments to 10G/11G on RAC platform and applying the new released patches for the server software.
• Setting Real Application Cluster environment on tables, indexes, and Database in general.
• Supported the developers in writing new procedures, codes, triggers, and packages.
• Performed Data analysis, creating guidelines and procedures to be used by the Data Management Team/Architects.
• Performed both logical and physical design on existing Databases on Linux 5.3 platform (Suse/Redhat)
• Managed Oracle data guard, advanced replication, partitioning, flashback option, on Staging, Production, and Oracle client environments.
• Managed three teams: server engineers, system administrators and database administrators.
• Responsible for the overall performance of all the server systems in the production network.
• Used Relational Database design and stored procedures with Interface methods to migrate new applications to the Linux 5.3 platform (Suse/Redhat)
• Transforming models from logical to physical in implementing Oracle databases.
• Monitoring the Oracle Databases application performance including the hardware as required.
• Creating logical and physical data models, System migration using Informatica’s service oriented architecture (SOA) for shared data access, integration, auditing, and reporting.
• Monitoring production execution of all relevant systems for system stability and compatibility
• Usage of Oracle 10G/11G technologies such as RAC, Data-guard, Advanced Replication, RMAN, Flashback option, Partitioning, OEM, and Spatial.
• Providing full life cycle DBA support for Development, Test, UAT, Production Databases and providing 24x7 on call DBA support.
• Uses Enterprise Manager on a daily basis to maintain the database including the Data Guard, advanced replication, partitioning and spatial and flashback option on oracle 10G R2/11G

Confidential . St. Louis, MO

Sr. Technology Engineer (6 month Contract)

Responsibilities:

• Maintained Oracle databases on development, test, production, and supported PeopleSoft Maximum Availability Architecture (MAA), and developers with any application issues while executing projects.
• Supported the design, planning, and initial installation following the best practices of the PeopleSoft Maximum Availability Architecture of the PeopleSoft Internet Architecture and PeopleSoft server components including process scheduler, integration broker, etc.
• Designed and documented processes for applying / rolling patches to the PeopleSoft layered products(OHS, WebLogic, and Tuxedo) as well as PeopleTools
• Performed performance tuning, diagnostics, installation, configuration, load balancing, backup/recovery, sizing, space management, PL/SQL tuning, diagnostics, use of Oracle's 10G/11G Enterprise Manager tool and optimization of the oracle databases for financial and human resources application/business users to meet company goals.
• Supported installation and configuration of the first PeopleSoft HRMS environment (DBMS, Web, App, etc.) in the PeopleSoft MAA design
• Maintained the end-to-end technology stack that included: brokerage client applications and connectivity methods, web and application servers, networking, database integration, and federation techniques on HP-UNIX, Linux (Redhat), and Windows operating systems, EMC Storage Area Network (SAN), and Tivoli Storage Management (TSM)
• Created new users, assigned them passwords, authentication, modified and updated existing physical databases (Oracle 10G/11G) in all environments.
• Leveraging and maintaining complex database design elements such as: Partitioning, materialized views, star schemas, clusters, bitmap indexes, indexed tables, PL/SQL packages, functions, procedures, object types, XML schemas, and Compression
• Assisted People-soft developers with SQL statements, queries, application tuning, and database design quality review, and enforcing Database design standards.
• Designed highly complex logical and/or physical databases, lead highly complex data modeling, mapping, integration, capacity planning efforts, developed management policies, procedures and standards, business requirements identification, analysis and development
• Managed applications methodology, technical design functions and assigned database system capabilities and administration activities on Oracle 10G/11G and SQL Server 2005/2008.
• Conducted security Audits, creating security reports and profiles
• Created logical & physical data models, tables, procedures, indices, & constants on Oracle.
• Used Materialized views in performance tuning and to help in processing data.
• Performed Oracle Database upgrades and applied patches on a regular basis per business requirements from the end users.
• Participated in project planning activities and provided time estimates for tasks and deliverables.
• Maintained the table spaces, data files, redo logs, rollback segments, and archive logs.
• Wrote HP-UNIX/Linux (Redhat) scripting for automated Database maintenance related using Korn shell and Perl.
• Performed Oracle installation, configuration, patches, upgrades, and supported RDBMS software when necessary and the associated Oracle Technology stack in a multi-tier environment including: database server, applications server, web server, reports server, forms server, admin server, and discoverer server environment.
• Assisted with disaster recovery planning, strategy, periodic testing, and implemented structural Database changes and migrated those changes from development-test-production.
• Created and maintained Oracle Database structures including the schemas.
• Patrolled and monitored the database alerts for any critical business issues using BMC patrol.
• Performed database refreshes on a regular basis per the request from application developers and the end users using export and import utilities and using advanced replication.
• Maintained the RMAN backups and daily processing batches on the HP-UNIX/Linux (Red-hat) platform/environment.

Confidential ., St. Louis, MO

Sr. Enterprise Oracle Architect

Responsibilities:

• Maintained Oracle, SQL, databases including backups and RMAN. Performed basic database functions and fundamental data modeling tasks including E/R modeling, constraint design, attribute definition, and designer 2000.
• Managed Oracle 9i/10G, SQL Server 200/2005/2008, LIMS, and SAP, database systems including design, analysis, debugging, performance characteristics and recovery activities.
• Building security processes that meet security guidelines and documentation
• Worked directly with users to define requirements, internalize the requirements and translate them into technical terms to extract data from an oracle data warehouse using ETL processes. Designed Microsoft SQL 2000/2005/2008 relational objects such as tables, stored procedures, triggers, & DTS packages (Data transformation services)
• Maintained systems configuration to support changes necessitated by new or changed processes and procedures.
• Planned, managed, and directed the activities for a team consisting of Oracle/SQL DBA’s responsible for operations, support, development, and implementation.
• Responsible for assigning individual responsibilities, identifying appropriate resources needed, and developing schedule to ensure meeting deadlines of projects and timely completion of project.
• Performed installation, Configuration, patches, upgrades, and supported Oracle Data warehouse, DBMS software, LIMS, and SQL Server 2000/2005/2008.
• Designed, implemented Real Application Cluster and supported Oracle/SQL relational database management system on a UNIX/Linux (Red-hat 5.3) platform and parallel server/RAC.
• Created and managed Oracle 9i/10G relational objects (tables, indices, stored procedures, triggers, rollback segments, and Redo logs. Performed problem diagnosis, performance tuning, capacity planning and configuration management.
• Managed and coordinated the resolution of technical and system configuration problems on an on-going basis. Performed tuning of the Oracle, SQL, objects to improve the performance that crossed multiple platforms through various processes to yield higher production. Worked with Oracle utilities, backup procedures, and recovery processes including PL/SQL, and RMAN.
• Created logical and physical data models, tables, and indexes, constants on Oracle, and SQL Server.
• Used Business Objects XIR3 as a reporting tool for the Data warehouse.
• Managed the integration of team play with other systems, including document tracking, financial, Computer based training, and LIMS. Managed and setting up Oracle data guard, including Oracle client environment.