Post Job Free

Resume

Sign in

Oracle Database Dba

Location:
Rocky Hill, CT, 06067
Salary:
$200k
Posted:
August 18, 2023

Contact this candidate

Resume:

Mark S. Sumoski

** ******* *****

Rocky Hill, CT 06111

860-***-****

ady1fm@r.postjobfree.com

PROFILE

Over Twenty years as Senior Project DBA/Senior Database Architect at Eversource Energy. A dedicated, loyal, and self-disciplined individual who has interpersonal and professional skills necessary to provide leadership, develop positive relationships with co-workers, senior management, IT service suppliers, vendors, and customers. Possesses leadership, team building, problem solving, and excellent communication skills.

Was responsible for the inception, development, standardization, and support of the overall Oracle database environment at Northeast Utilities/Eversource. The environment has since grown to over 1500 databases on 500 servers primarily on the AIX operating system with a small percentage on Windows and Linux.

Direct experience with WebLogic server administration. Installed, configured, and supported 10 new stand-alone and 6 clustered WebLogic domains.

Nine months hands on experience as a MS SQL application DBA.

Managed a team of 10 DBAs and consultants supporting Oracle, MS SQL Server, and ESSBase technologies.

Over five years as a Sybase DBA and Technical Lead. In depth experience supporting Sybase, ASE, Replication Server, Omni/Mainframe Connect running on Sun/Solaris and Windows.

Following a company merger and the resulting new IT reorganization, has taken on the role as an Oracle DBA Architect Oracle technology lead providing dedicated services and support to various major business projects.

During the IT department’s outsourcing transition, was directly engaged with the new IT supplier’s offshore staff to provide knowledge transfer, mentoring, and direction to help position them to take over the operational support responsibilities of our established Oracle database environment. Maintains a positive relationship with both local and offshore sourcing team members. Continues to work closely with them to ensure ongoing quality support to our business areas.

Currently consulting through Gridbright, Inc providing Oracle technology support for major project initiatives with major utility companies.

TECHNICAL SKILLS

Has in depth experience configuring, consulting, and providing hands on support for Oracle database technologies that include RAC, Data Guard (physical and logical standby), performance and tuning, troubleshooting, Rman, Grid Infrastructure, ASM, OEM/Grid Control, EM Express, Partitioning, Oracle Networking, Oracle Client, Materialized Views, Data Pump, and Database Security. Proficient installing, upgrading, and migrating Oracle database software on AIX, Windows, and Linux. Experience with Oracle 10g, 11g, 12c, and 19c database technologies.

Proficient with applying Oracle Grid Infrastructure and database software patch updates for stand-alone, RAC, and Data Guard environments.

Frequently involved with database performance and tuning activities using various tools including OEM Cloud Control 13c.

Performed ASM storage migrations moving from EMC Symmetrix to VMAX and EMC VPlex technologies.

Experience as a MS SQL, Sybase, DB2, and Oracle DBA.

Installed, configured, and built several WebLogic 10.3.6 stand-alone and cluster Domains on the AIX platform.

PROFESSIONAL EXPERIENCE

GridBright, INC

GridBright helps electric utilities implement and integrate distribution operations and emergency response systems.

Senior Database Architect

Currently represented in a consulting capacity through Gridbright, Inc providing direct support and leadership with creating, configuring, and successfully implementing an Electric Outage Manage system for the Eversource Energy company. Supported the design and build of the supporting Oracle database environment. This environment was built using 19c Grid Infrastructure/ASM, RAC, Dataguard, OEM Cloud Control 13c, Golden Gate, Site Guard, and WebLogic technologies. The database environment alone consists of over 50 databases and over 120 AIX servers.

Infosys LTD

Infosys is a service company that provides business consulting, technology, engineering, and outsourcing services.

Principal IT Consultant

Principal IT Consultant for the Infosys Corporation on the Eversource Energy account in Berlin, CT. Supports large company sponsored projects as a Senior Oracle DBA Architect. Employment at Infosys began when my position as a Senior Oracle DBA Lead transitioned to the newly contracted outsourcing supplier.

As a Senior Oracle DBA Architect, responsible for designing and creating the Oracle 12c database environment that supports the Supply Chain Management project. Designed, created, and configured 25 Oracle 12c database environments residing on 10 AIX servers for the project. Highly engaged with the project leadership team on a regular basis. Directly involved with discussions related to design builds, enhancements, project scheduling, and support requirements.

Primary Oracle project DBA Architect for the recently successfully deployed OMS (Outage Management System) project. Directly responsible for building, configuring, and deploying, 36 Oracle 11gR2 database environments, 6 Oracle RAC 2 node database clusters, 4 Oracle Data Guard 2 node RAC physical standby database environments, 10 WebLogic stand-alone and 6 WebLogic Cluster domains. Installed and configured the Oracle Grid Infrastructure/ASM software components used for database storage to support the above Oracle database environments.

Lead Oracle project DBA Architect and primary contact, directly involved with all relevant project meetings, performance testing, required off-shift activities, consult on project architectural design, and delegation of offshore resource project support as required.

Eversource Energy, Berlin, CT

New England’s largest utility provider serving more than 3.5 million electric and natural gas customers in Connecticut, Massachusetts and New Hampshire.

Manager/Supervisor Midrange Database Technologies

Managed a team of 10 DBAs and held responsibility for the entire Oracle, MS SQL, and Essbase technologies for the Northeast Utilities Energy Company.

Responsible for key technology decisions and setting direction for the Midrange database environment.

Conducted annual and mid-term reviews, set team and individual goals, directly handled the selection and contracting of supplemental consulting resources as needed.

Managed license purchases, annual maintenance and support fees including the related budget for related database software.

Senior Oracle DBA Project Lead

Directly involved with the Oracle database environment integration initiative between the merged Northeast Utilities and NSTAR corporations. Quickly learned configuration standards and layout of the NSTAR Oracle environment. Helped develop and publish the new hybrid database environment standards during this effort.

Supported several new business project initiatives for the merged operating companies serving as the primary Oracle project DBA. Support included building new Oracle database environments under the 11gR2 version, applying the latest Oracle patch sets, providing direct project DBA support setting up associated support and monitoring scripts including RMan database backups using Data Domain.

Responsible for incepting and developing the Oracle database environment at the Northeast Utilities Corporation. Established configuration standards and supporting documentation. During its evolution responsible for recruiting, building, leading, and mentoring a team of DBAs to help provide ongoing support of the growing Oracle database environment.

Responsible for the initial decision to use Oracle ASM storage for our first Oracle RAC database environment. Recommended the Oracle ASM storage model as the new standard for the Oracle database environment going forward in lieu of previously used Unix File System storage for database file structures.

Directly supported an ASM migration from EMC Symmetrix to EMC VMAX hardware for over 40 Terabytes of storage for all underlying Oracle databases. Also supported a similar initiative to move from EMC VMAX to EMC VPlex.

Provided 24x7 production On Call support for the entire database and related business application systems.

MS SQL Server DBA

With a Sybase background, was able to quickly adapt to a secondary role as a MS SQL Server DBA supporting application request activities as needed. Performed this support role for approximately nine months.

Sybase Database Technical Lead

Held the Lead Database Administrator role supporting the entire Sybase database environment for Northeast Utilities.

Configured a Sybase Replication server environment consisting of 12 Satellite Sybase databases located on 12 servers in various locations throughout the state that monitored environmental data. The data from the satellite sites was rolled up to a central reporting site using Sybase Replication Server Technology. Also configured Sybase Replication Server to support a mobile computer application.

Configured Sybase OMNI/Connect which heterogeneously integrated Sybase database data with DB2 Mainframe data. This design provided a single relational data interface for a key business application.

Managed the entire Sybase database environment providing application DBA support, applying EBF bug fixes, supporting version upgrades, configuring backups, performance and tuning, and troubleshooting.

COMPUTER SKILLS

Languages: SQL, PLSQL, Unix Shell Scripting, VI editor, Windows batch scripting.

Operating Systems: AIX, LINUX, Sun/Solaris, Windows Server.

Software: Oracle RDBMS 7, 8i, 9i, 10g, 11g, 11gR2, 12c, 19c, IAS, Oracle RAC, Oracle Data Guard, 12c EM Express, Oracle Cloud Control 13c, OAS, WebLogic 10.3.6, RMAN, Sybase Adaptive Server Enterprise, Sybase Replication Server, DB2.

Tools: DBArtisan, Erwin, OEM Grid Control, 12c EM Express, TOAD DBA Xpert, SQL Navigator, Confio Ignite (Solar winds), Red gate Schema Compare, SQL*PLUS.

EDUCATION

BS in Administrative Science, Central Connecticut State University

Computer Science certificate Morse School of Business

TECHNICAL TRAINING

Oracle Database Administration, Oracle RAC, Oracle Data Guard, Oracle Performance and Tuning, Oracle Golden Gate Workshop, Oracle Backup and Recovery, Oracle Networking, Sybase Database Administration, Sybase Replication Server, Attended Oracle Open World (2005-2010).

PROFESSIONAL DEVELOPMENT TRAINING

Supervision Training, Sexual Harassment Training, Project Management, Time Management, Diversity Awareness.

PROFESSIONAL REFERENCES

Will provide upon request



Contact this candidate