Enterprise Database Architect Resume
2.00/5 (Submit Your Rating)
SUMMARY:
- Problem solver who uses creative and innovative solutions to meet requirements.
- Highly detail - oriented while also keeping the big picture and overall objectives in sight.
- Extensive knowledge and operational experience with multiple databases.
- Expert in crafting highly-available solutions using clustering, partitioning and replication.
- Shares technical knowledge and solutions through formal and informal training and mentoring to enable others to be successful.
TECHNICAL SKILLS:
Databases: Oracle 11g & 12c, Oracle RAC, Tibero, Teradata, SQL Server, MySQL
Replication: GoldenGate, Data Guard (logical and physical), MV Replication
Monitoring & Alerting: Oracle Enterprise Manager (OEM)
Languages: SQL, PL/SQL, UNIX Shell Scripting (bash, ksh, sh), Java, C/C++
Platforms: UNIX (Red Hat Linux, Solaris), AWS RDS & EC2, Microsoft Windows
PROFESSIONAL EXPERIENCE:
Confidential, Southlake, TX
Enterprise Database Architect
- Defined cloud database use cases: full port to cloud, mixed cloud / Confidential implementations, cloud-bursting, geolocation.
- Evaluated database offerings: AWS EC2 & RDS, IBM Bluemix/SoftLayer, Rackspace, Azure, and Oracle. Provided database perspective in the selection of a preferred provider.
- Created standard AWS database architectures: low availability, medium availability, high availability, and/or high capacity.
- Investigated and defined AWS data replication options: one-time and ongoing replication within AWS and between Confidential data centers and AWS.
- Defined AWS database selection strategy: Oracle, MariaDB, PostgreSQL, Aurora, MySQL, or SQL Server.
- Ensured cloud implementations met non-functional requirements: performed governance review and sign-off on database selection and architecture.
- Defined Oracle license strategy: bring your own license or use AWS supplied license.
Confidential, Southlake, TX
Enterprise Database Architect
- Reduced database outages, improved performance, and simplified maintenance: standardized database architecture and configuration, defined standard implementation patterns for different service levels, implemented periodic configuration audits and drove remediation. Created and chaired the database standards committee that investigated and approved standards changes.
- Increased data security: defined remediation plans for PCI, SOX and GDPR compliance.
- Reduced costs, improved time to market, and increased maintenance efficiency: justified, implemented and operated Confidential ’s private Oracle database clouds that provided DBaaS. Incentivized good project behavior by making it a zero cost option. Database server count for targeted applications reduced by 90%.
- Expanded effort to cover larger and more critical applications while mitigating increased risk.
- Created Oracle license cost management strategy: using VM isolation, Oracle consolidation, 12c efficiency features, porting of existing apps to an Oracle compatible database and implementation of new apps on a lower cost RDBMS or NoSQL, as appropriate.
- Ensured that database service quality would not be compromised by insourcing: key member of planning team, lead 1 st transition wave, and resolved issues for each subsequent wave to insource support for 600+ databases.
- Reduced outage and performance issue recovery and analysis times: justified and implemented OEM for all Oracle databases (previously Confidential personnel had very limited visibility into the operations of our databases). Provided training in usage of OEM.
- Improved quality of interactions with Oracle support: defined and documented best practices and escalation paths and ensured that these were well known by all of the DBAs.
- Reduced license and maintenance costs: established Oracle as Confidential ’s standard database and instituted governance, requiring justification when other databases were used.
- Evaluated new capabilities and technologies:, NoSQL databases (MongoDB, Couchbase, Cassandra, Hadoop), Tibero, advanced Oracle features and Oracle appliances (Exadata and ODA).
- Oracle expert who provided 2nd tier support for 300+ production databases and 50+ operational DBAs. Ongoing knowledge transfer through documentation, training, and tools.
Confidential, Southlake, TX
Data Engineer, End-to-End Engineering
- Provided database architectural and technical direction and support to mission critical projects. Designed, clustered, partitioned, and replicated architecture patterns for systems needing high - capacity and/or highly-available databases.
- Enabled application migrations from mainframe to Linux.
Confidential, Southlake, TX
Data Architect
- Data architect for the eHotels project that moved shopping from a mainframe (IBM - TPF) implementation to a highly available open-systems implementation.
- First implementation of Oracle RAC at Confidential .