Database Administrator Information Technology

GREGORY SIGALOVICH

Vernon Hills, Illinois ***** ***********@*****.*** www.linkedin.com/in/gregory-sigalovich

SUMMARY

An accomplished and goal-oriented database administrator with demonstrated expertise in enterprise systems solutions, database creation and management, project life cycle development, consulting, installations, integrations, migrations, testing, issues resolution, team training and development, tutoring, mentoring, and performance monitoring. Proven aptitude for designing and implementing cost-effective database solutions that enhance business functionality and performance. Excels at prioritizing multiple competing tasks in demanding environments. A creative leader and analytical thinker who makes decisions to benefit the financial position of the company and obtain lasting results.

EXPERIENCE

TransUnion, LLC, Chicago, Illinois

Senior DBA, 04/2007-07/2024

Environment:

OS: Linux Reda 5.x -9.x, AlmaOS 8.x, AIX 5.x, 7.x; Windows

Shell/languages: bash, ksh, awk, PERL-5.0, SQL, PL/SQL; DCL; VAX COBOL

Databases: DB2 UDB(LUW): 9.x-11.x, CDC 6.3, 10.2, 11.4, Q-Replication, HADR, TSA

Oracle 11g/12c/19c Exadata X6; GoldenGate 18.1, 19.1, 21c; OEM 12.x, 19.x; Data Guard, AWR/ADDM

Postgres 9.6 -12, PGAdmin 4x, Foglight 7x, RepMgr 5x;

3rd Party Software: AutoSys 13.1; Splunk 9.x; Agile/Jira; Pacman, Toad 16.x, SQL Developer; AWS; TSM, CommVault

Lead large complex database design projects. Provide integration on various RDBMS systems. Data modeling using Erwin tool. Perform project planning, define Jira tasks, and coordinate tasks between project team members.

Mentor newly hired onsite and offshore database developers in new features of DB2 LUW, Oracle Databases and Postgres databases. Implement IBM and Oracle best practices for application development.

Provide SQL training including SQL query creation and initiative-taking tuning.

Design and implement Q-replication, bidirectional CDC and Goldengate replications. Define subscriptions and data exchange between production databases. Configure Golden Gate extract, datapumps and replications.

Utilize Grid Control, ASM and Flashback tools to administer multi-node RAC and Exadata environments.

Implement High Availability of databases using DB2 HADR, Oracle Data Guard and Postgres streaming replications.

Play key role on DBA community board to provide recommendations on database management strategies and best practices and implementation of database systems and architectures, scalability, and storage capacity planning for production servers. My recommendations on server consolidations reduced costs by 35%.

Responsible for the databases and client’s installations, applying fix packs, migration of databases from DB2 LUW V8 to DB2 LUW 11.5, Oracle 12g to Oracle 19c, Postgres 9.6 to Postgres 12. Perform maintenance, monitoring, problem resolution, and managing database integration activities.

Utilize project lifecycle development expertise (Dev, QA, UAT, and production) according to mandated compliance, including SOX, HIPAA, and PCI.

Led database multiple schema development, implementation of triggers, stored procedures, and database-specific shell scripting on Unix (AIX / Linux). Directed design, development, and implementation of database monitoring and administration scripts scheduled through AutoSys, Cron, and Splunk / Zenoss for logs scraping and directories sizes monitoring.

Develop PL/SQL stored procedures, triggers and scripts for data manipulation, validation and loading data from files into database.

Complete database system and SQL performance tuning by rewriting SQL and using Snapshot, Table Function, Event Monitor, and OS commands (topas, vmstat, and iostat), updating DB, DBM, and DB2registry configuration parameters, using db2top, db2exfmt, and db2expln tools, and running reorgchk, reorg, runstats, and db2rbind commands, OEM monitor and alert capabilities. Generate and analyze AWR /ADDM reports to identify areas of Oracle database performance improvements.

Experience with oracle SQL Plan Management package in maintaining oracle plan stability for optimal database performance by creation of plan baselines, correction of inefficient plans using oracle SPM package, transferring of plan baselines between database environments.

Implement and manage Database Security, using OS group and user ID, DB Authentication, DB Authorization, and database object privileges.

Set up Tivoli Storage Manager (TSM) and CommVault for storing database backups. Perform backup/ restore of production databases into UAT and NPP environments. Perform DB2 export/load/import, Oracle, and Postgres data pumps for moving data between environments. Setup Postgres backups using pg_dump, pg_basebackup for physical and logical backups.

Migrate Db2 and Oracle to Postgres databases, and manage AWS using EC2, Postgres and SES services.

Lead critical database VTM patching and remediate security vulnerabilities on different databases.

Develop and support data warehousing environment, using Informatica and Hyperion tools. Ensured resolution of complicated database production problems working with IBM and Oracle.

Provide 24 / 7 production support for Exadata Oracle, Db2 and Postgres databases.

ADDITIONAL EXPERIENCE

Health Care Services Corporations (BCBS), Chicago, Illinois, Senior Application DBA, 2005-2007.

Environment: Bash, ksh and AWK, Perl 5.0, Business Rules 2.0, Java 1.4, XML, DB2 LUW 8.2, Servlets, JSP, J2EE, WebSphere 5.1, AIX 5.3, Windows NT, and Zena 2.1.

Oversaw database migration across subsystems to create working environments for development, test, and production. Monitored databases for size and structure changes and made application adjustments accordingly. Analyzed developers’ SQL for possibilities of optimization using DB2 explain and adviser utilities.

Rose International, Hoffman Estates, Illinois, Application DBA, 2003-2005.

Provided consulting services for AT&T, Inc.

Environment: SQL, C, XML, Bash, ksh, AWK, DB2 v8.2 LUW, and AIX 4.3.

Performed full database restore, tablespace online restore, redirected restore, and roll forward recovery under various circumstances. Managed management of table space growth, monitoring data files additions and extent growth. Involved in granting various authorizations and privileges to different users. Managed documentation for various database procedures.

Thompson Financial Media, Skokie, Illinois, Senior Software Engineer, 2000-2003

Environment: SunOS 2.7, Windows NT, Java 1.3, HTML 3.2, XML, JavaScript, Oracle 8.1, Db2, Servlets, Java Swing, J2EE, JavaBeans, Java e-mail tools, Perl 5.0, WebSphere 4.0, Tomcat 4.0.

Ameritech, Hoffman Estates, Illinois, Analyst, 1996-2000.

Environment: VAX / VMS 6.1, Windows NT, HTML 3.2, Java 1.2, JavaScript, ASP 2.0, Perl 5, Oracle 7.3, RDB 8.0, DCL, and VAX COBOL.

EDUCATION

MOSCOW STATE UNIVERSITY OF CIVIL ENGINEERING, Moscow, Russia

M.S., Civil Engineering

PROFESSIONAL DEVELOPMENT

IBM DBA, IBM

Oracle Database 11g Administration Workshop 1, 2, Oracle

JAVA Developer, DePaul University

WEB Developer, DePaul University

Advanced COBOL Development, DePaul University

Contact this candidate