Security Tools Administrator Resume Albany, NY - Hire IT People

SKILLS SUMMARY:

WORK HISTORY:

Security Tools Administrator

Confidential, Albany, NY

Responsibilities:

Worked along side Operations and Security Teams to stabilize their current LogRhythm SIEM platform.
SQLServer was utilized as the database supporting the SIEM.
I upgraded platform( Windows 2000 to 2016 and SQLServer2012 to SQLServer2016) and enhanced the security monitoring to meet the Confidential needs.
Having DBA experience was necessary to support maintenance and researching issues and we had many occasion to utilize my knowledge of transaction logging to resolve system and performance issues.
And I did utilize my skills to support maintenance and researching issues.
I did have many occasions to utilize my knowledge of transaction logging when issues occurred.

Database Developer

Confidential, Saratoga, NY

Responsibilities:

Installed and tuned Postgres database.
Migrated DB2 procedures to Postgres.
Worked with Development team to remove some processing in Java to procedures to bring nightly processing from over 24 hrs to 2 hrs.
Developed model VMs for customer installations and began migrating customers to Postgres platform.

DataAnalyst

Confidential, St, Albany, NY

Responsibilities:

Extracted Data From Oracle database(s) for graphical input to web pages for clients.

Database Developer

Confidential, Queensbury, NY

Responsibilities:

Position required developing and maintaining many procedures ( T - SQL and PL/SQL) for Sybase and Oracle in addition to many triggers and functions.
Responsible for replication/transformation from Sybase to Oracle/AWS and Postgres environments using Sybase replication and custom procedures.
Developed and maintained several java applications in conjunction with HTML to support some of our monitoring tools.
Used UNIX shell and perl scripts in combination with PL/SQL, crontab for some database maintenance( update statistics, DBCC checks,ANALYZE and DBMS STATS) and preventative alerts.
Performance monitoring and tuning of Sybase and Postgres environment.
Provided rotational oncall support for all database activities.
Reviewed and recommended design standards for all database design.
Often tuned queries for myself, application developers,and team members using query plans, cached plans, etc for increased efficiencies.

Lead Applications Developer

Confidential, Albany, NY

Responsibilities:

I migrated Unix scripts from SunSolaris to Linux RedHat as well as coding several new Sybase procedures and refactoring existing PL/SQL procedures.
Several new applications in Java were required, all to support the merge.
We upgraded Oracle from 8 to 9i and converted their SQLserver apps into Oracle.
Many new applications in Java were necessary and a new Oracle schema were architected to support a Data repository for regulatory reporting.
There were several customized MS Access data feeds we supported from the Oracle data warehouse .
I then joined their Risk and Compliance department developing Anti-Money Laundering systems for Fraud Detection that utilizes an Oracle 9i/linux application with Java and Informatica interfaces. AbInitio is used to extract data required for money-laundering analysis from the legacy mainframe data repositories.
I converted from Business Objects to Cognos all reporting.
After the merge, we reviewed and redesigned our MSSQL databases that supported our web faces to assure it accommodated all our new business.

Contracted Programmer

Confidential, Albany, NY

Responsibilities:

Unix and Oracle Database developer for Confidential .
Developed Testing Utilities using Unix script, PL/SQL,HTML,Java and implemented upgraded Claims processing system.

Programmer

Confidential, Albany, NY

Responsibilities:

Developed Fraud datacapture system with Domino Forms frontend and converted Access
DataBase to Oracle Database. Reviewed and designed PL/SQL procedures to audit data transformation maintained for their International Leasing System.