We provide IT Staff Augmentation Services!

Principal Technologist/ Sr. Database Architect Resume

4.00/5 (Submit Your Rating)

GeorgiA

SUMMARY

  • Result driven IT Manager with in - depth experience in Software Development, Logistical, ERP, Banking, Security, Professional Services, CRM, Health Care applications and Infrastructure and Operations Support.
  • Proven abilities as a “hands on” tactical and strategic project manager, reducing costs while improving systems performance, capacity and time to market.
  • With broad based technical experience in various hardware/software platforms.
  • Maintains partnerships across teh organization, and teh ability to influence senior management, peers and staff through an inclusive style and recognition of their abilities to achieve results.
  • Achieved success through repeatable processes, reshaping inefficient operations and impacting profitability for teh enterprise. Demonstrated experience in teh following areas:

CORE COMPETENCIES

  • Infrastructure Architecture
  • Policy/Procedure Implementation
  • Budgeting /Forecasts / Corporate Accounting
  • Process Reengineering
  • Capacity Management
  • Vendor Relationship Management
  • Project Management
  • Configuration and Release Management
  • Disaster Recovery and Planning
  • Database Management and Financial Forecasting
  • Management Reporting and Tools
  • Leadership and Mentoring
  • Enterprise Resource Planning
  • Decision Support Systems
  • Operational Support Systems
  • Logistical Systems
  • Storage and Data Security
  • Performance Measurement

TECHNICAL SKILLS

Systems & Web Servers: UNIX, HP-UX, IBM AIX, SUN Solaris 8, 9, 2.x, LINUX, Redhat 5 & 6, PC, AS/400, Nokia, Solaris, LINUX SuSE, Red Hat, Windows, EMC2. TSM, Windows 2008, Apache Tomcat, WebSphere, WebLogic, SUN Fire, E2900 server, Informatica and Power Exchange, SAN 3400, SAN Storage, VMWare, NetApps, OVM (Oracle Virtual Machine)

Databases and BI Tools: Oracle Grid Control 12c, Oracle 12c, 11g R2 & 10g, Oracle 9i, Microsoft SQL Server 2012 and 2008 and 2005 Cluster, MYSQL, DB2 9 and 8, DB2 UDB,Clustering, Failover, Real Application Cluster (RAC), Standby databases, Oracle EBS (eBusiness Suite R12, Active/ Passive database, Active/ Active database, Data Warehouse, Cognos PowerPlay, ReportNet, ClearQuest, Data Warehouse, ODS, Oracle Grid infrastructure, ASM, Oracle Enterprise Manager (OEM), Data Guard, SAP, JD Edwards, Streaming, Log Shipping, Database Clone, SSAS, SSIS, SSRS, Oracle Enterprise Manager, SSMA, APEX

Financials and Storage: Oracle E-Business Suite R12, 11i, Payables, Receivables, Assets, General Ledger, EMC, TSM, RAID, DAS,NAS, Oracle Enterprise Manager (OEM) 11, NetApps, SANS, EBS Cloning

Tools: and Office: Oracle Designer, Power Designer, Database Designer, Erwin, Word, Power Point, MS Project, Access

Management Tools: OEM, Oracle Performance Tool, SQL Enterprise Manager, SQL Analyzer, TOAD, ETL (Informatica)

Disaster Recovery: Disaster Recovery planning, Contingency planning, documentation experience, Veritos, RMAN

E-Commerce Suites: Net Commerce, iCat, Server Side e-commerce, WebSide Pro, Intershop, Web Sphere, WebLogic, Apache

Communications: LAN/WAN, TCP/IP, DHCP, Winframe, PCAnywhere, Procomm, Telnet, X- Windows

Firewall: Check Point NG, Cisco PIX, WatchGuard, VPN

IDS: Confidential RealSecure, Confidential Suites of Products, Cisco NetRanger, Snort

Languages: HTML, Java, ASP, Oracle Developer, Remedy ARS, Oracle Forms, SQL* Plus, TCL, XML, PL/SQL, Access, dBase, Business Basic, Visual Basic, Data Security, Power Builder, Crystal Reports

PROFESSIONAL EXPERIENCE

TEMPPrincipal Technologist/ Sr. Database Architect

Confidential, Georgia

Responsibilities:

  • Designed, developed and implemented processes for implementing E-Business Suite Application and Infrastructure patches.
  • Project Manage ERP System upgrade which include new hardware, cabling and network.
  • Upgrade ERP and databases
  • Part of a team dat support over 270 Oracle databases
  • Spearheaded an ERP Dashboard dat in capsulate work products trending, system growth and system capacity performance trend
  • Streamline E-Business Suite Cloning through automation dat resulted in an efficiencies dat freed-up 70% of resources time to focus on other initiatives.
  • Implement additional Oracle 11g RAC dat included, hardware, cabling, switches, ports and configuration.
  • Consolidate databases to be part of a commodity cluster dat resulted in license cost, data center storage and resources cost
  • Hands-on experience in Red Hat Linux which include writing scripts
  • Create proactive database alerts and automatic resolutions.
  • Manage cost associated with cross-functional projects.
  • Provide automation throughout E-Business Suite Infrastructure while sending warning and critical alerts to mobile devices.
  • Communicate with senior executive leadership team members from different line of businesses and departments dat sponsored business initiatives.
  • Create executive dashboards for senior leadership team dat shows trending and aide in decision support
  • Troubleshoot and resolve technical and functional issues related to Oracle databases and E-Business Suite R12.
  • Tune E-Business Suite APPS/ Web, SSO/OID and Concurrent Managers tiers.
  • Support a variety of ERP database systems such as SAP and EBS R12.

DBA Team Lead

Confidential - Georgia

Responsibilities:

  • Designed, developed and implemented teh upgrade of Oracle 11g R2 RAC databases in five environments.
  • Oversee teh upgrade of Oracle E-Business Suite application from 10.7 to R12 which includes Oracle Financials, Accounts Payable and Receivable.
  • Managed over 300 SQL Server 2005 and 2008 databases.
  • Provide 24x7 supports to customers in teh United States and Mexico.
  • Designed and implemented Oracle Enterprise Manager (OEM) 11g for managing, monitoring and alerting
  • Managed Log Shipping of SQL Server Database logs to Disaster Recovery (DR) site.
  • Managed Oracle six nodes and three nodes RAC Oracle databases.
  • Assist functional team members with resolving front-end issues dat resulted in poor back-end performance within teh following Oracle EBS modules:
  • Order Management, Accounts Payable, Account Receivables, General Ledger, Procurement, EB Tax, Manufacturing, I-Expense and Fix Assets
  • Created Service Requests (SR) with Oracle Support on software problems, and performing application configuration setups.
  • Worked with developers, business functional units and other customers to aide in teh development of teh back-end business processes
  • Assisted with performing thorough testing of application changes, system and regression testing, adhering to standards and practices dat meet Quality Assurance (QA) and ISO standards.
  • Investigate, research, test and implement Oracle patches
  • Wrote SQL code to resolve issues such as stuck workflows, applimation issues and CCM related.
  • Resolved issues related to printing within EBS including CUPS.
  • Followed SOX Guidelines related to responsibilities and security within EBS.
  • Maintained Appltop and Common top
  • Maintained Oracle Single Sign-on (SSO)
  • Identified and resolve problem data
  • Ran various reports and health checks such as:
  • Account Payables Trial Balance Reports
  • Tax Transaction Audit and Reconciliation Reports
  • Complete distribution, transfer, and tieback of expense reports
  • Prepare batch snapshot
  • Periodically review, act on, and dispose of information in OPM MRP interface table.
  • Update Forecast headers in Forecast Set
  • As needed, update Currency Code setup in Global Contracts defaults
  • Legal Entities and Establishments
  • Performance tune all custom code including create additional indexes if needed.
  • Currently supporting Oracle EBS 6 Nodes RAC
  • Supporting 6 Oracle 10g database, 6 Nodes Concurrent Mangers Nodes, 6 Nodes Applimation Servers.
  • Over 7 Terabytes of EBS Oracle Data
  • Support Oracle Discovery server.
  • Upgraded Oracle 10g databases to Oracle 11g R2 databases including ASM and teh Grid Infrastructure.
  • Assisted with Configuration and Maintenance of Oracle Apps 11.5, Concurrent Manager Administration, Forms server and Web server administration, User and Profile Management
  • Implemented Oracle Data Guard and SQL Server Log Shipping
  • Identified and scope potential opportunities, determining risks and constraints.
  • Managed risk and control issues with multiple groups of developers and business analysis for tighter integration between Software Development teams and other Shared Services areas.

Sr. Oracle DBA (Consultant)

Confidential

Responsibilities:

  • Managed Oracle 10g RAC and non RAC databases on both Linux and Solaris Platform.
  • Supported online web applications, B2B applications and Credit Cards processing applications.
  • Design, create, implement, and manage database sizes from 3 Gigs to 2.3 TeraBytes.
  • Managed over 120 SQL Server 2005 databases.
  • Upgraded Oracle 9i database to Oracle 10g RAC database.
  • Team lead on many applications and databases upgrade and migration.
  • Tuned Oracle production databases and SQL statements.
  • Setup alerts and notifications for each application environment.
  • Created project plans and manage teh implementation of a variety of database related projects.
  • Provided 24x7 applications support
  • Migrated Sybase database to Oracle 10g RAC.
  • Utilized Oracle Grid and OEM to manage database environments.
  • Monitored Oracle databases using OEM, and developed tools.

Manager of Database Services

Confidential, Georgia

Responsibilities:

  • Manage teh department to meet balanced scorecard targets by:
  • Monitoring operations progress towards metric targets
  • Supervising operations service performance based on service level agreements (SLA)
  • Monitoring on-time delivery of work by teams
  • Actively participating in Continuous Improvement-related initiatives to minimize unfavorable variances
  • Monitoring Operations budget, and ensuring dat budget underruns enable sharing of resources
  • Actively encourage and contribute to teh development of noledge capital (e.g., innovative systems solutions, development techniques, and implementation strategies) through succession planning
  • Lead a team of Oracle Database Administrators (DBA), SQL Server DBA and DB2 DBA
  • Managed department budget of over $ 1.2 million.
  • Supported over 20DB2 databases on IBM AIX and Linux environments
  • Managed strategic projects including migration teh Data Warehouse to Oracle RAC and implementing data cleansing and quality systems
  • Redesigned ETL strategy to improve accuracy and reduce latency and conducted all code reviews on transformations & assigned tasks
  • Managed 25 SQL Server 2000 Enterprise Databases servers
  • Designed and implemented database systems, provided code reviews, conducted changes and monitoring of performance of SQL Server, Oracle and DB2
  • Managed Data Warehouse and Data Mart databases in DB2 AIX environment.
  • Created Informatica ETL packages for transferring data from Oracle, SQL Server and DB2 into our Data Warehouse database
  • Used Cognos PowerPlay for Data Warehouse reporting and Dashboard
  • Developed contingency and Disaster Recovery plans
  • Implemented GPS systems on all service technicians’ trucks in USA and Canada
  • Consolidated databases to reduce cost and manageability
  • Implemented our Disaster Recovery Backup and Restore Procedures
  • Implemented database backup strategy based on applications needs
  • Maintained thorough accurate and up-to-date documentation of network systems, operational procedures, network topology and asset management

Operations Lead

Confidential - Georgia

Responsibilities:

  • Lead a team of analysts dat travels to 50 States Health Departments
  • Worked with 50 states Health Department to send information into a centralized Confidential database
  • Tier Level 3 Support for teh Biosense and AIDS/HIV Real-Time Data Brokering and Messaging application
  • Managed over 25 SQL Server and 10 Oracle databases servers
  • Transferred AIDS/HIV data from 50 States into a centralized Confidential Data Warehouse SQL Database.
  • Generated reports and created views for Ad-Hoc Reporting from teh de-normalized Data Warehouse database for teh end-users
  • Supervised tasks relating to teh States providing HIV/AIDS data
  • Produced Ad-Hoc reports to senior management
  • Utilized Erwin to create database scripts, logical and physical diagrams, and manage data dictionary definitions
  • Database Administrator (DBA) for teh Biosense Data Brokering and Messaging (DMB) application
  • Created databases for both Oracle and SQL Server
  • Installed database software and patches
  • Create tables, triggers, stored procedures, views, etc.
  • Monitor databases
  • Manage databases information
  • Performance tuning
  • Assisted State Heath Departments with Confidential PHINMS certificates and encryption keys
  • Created and delivering teh daily operations status reports
  • Assisted in implementing new technologies, tools, software products, and processes necessary for teh operations
  • Configured, integrity, recovery coordination of network along with business continuity preparedness planning
  • Provided thorough, accurate and up-to-date documentation of network systems, operational procedures, and network topology and asset management

Product Manager/Automation Manager

Confidential - Georgia

Responsibilities:

  • Developed web applications dat tracked firewall and Intrusion Detection events for Managed Services customers
  • Implemented Oracle 8i and 9i, and SQL 2000 Fail-over solutions
  • Created Standard Documentation procedures for High Availability solutions
  • Trained Systems/ Field Engineers on implementing High Availability solutions when using Confidential products
  • Managed 7 DBA and 17 Developers in Atlanta and Southfield Michigan offices
  • Managed departmental budget and financial objects
  • In-directly managed teams from 27-50 Developers and DBA’s based on teh project/product requirement
  • Provided High Availability solutions for Oracle and Microsoft SQL 2000 databases in both Windows and UNIX environments
  • Developed Marketing Plan and campaigns to launch new products
  • Recommended security policies on where to place Intrusion Detection sensors inside and outside of you're networks
  • Deployed applications and databases in North America, EMEA, APAC and South America
  • Developed security policy scripts dat will identify attack signatures coming from particular sources
  • Managed fortune 500, 1000 customers security infrastructure
  • Provided automated security analyst reports to customers
  • Analyzed marketing information to determine teh type of security problems customers are challenged with in effort to reduce operational costs
  • Developed a business model for teh customer to include Managed Services in their offering
  • Provide Security Assessment and Strategy
  • Provided customers feedback to teh developers to increase usability of teh product
  • Developed application test and implementation plans

Technical Practice Lead

Confidential - Georgia

Responsibilities:

  • Managed team of 15 DBA’s and 20 developers in teh South-East regions
  • Technical lead on sale-calls to clients
  • Created Statement Of Work agreements between Confidential and clients
  • Provided pricing to clients for Confidential professional services
  • Generated over 4 million dollars in professional services
  • Provided e-Commerce, database and software solutions to clients
  • Saved Confidential in-house development over 3.5 million dollars
  • Managed multiple customers projects simultaneously
  • Oversee teh technological directions for large client projects
  • Provided leadership within teh company by mentoring, continual improvement of methods, tools and techniques
  • Represented teh company with consultants, vendors and service providers
  • Setup Oracle Financials GL dat includes account roll-up groups, defining FSG reports using Oracle Forms & Reports, cross-validation rules, and defining responsibilities
  • Uploaded budget data to production Oracle Financials database using Oracle's General Ledger Open Interfaces, and automated this process with interactive UNIX shell and SQL*PLUS scripts

We'd love your feedback!