Senior IT professional with over 10 years hands-on experience working in the
highly volatile and complex Financial Services sector. A Database Administrator
with a proven track record of team leadership and technical skills, who has the
ability to work on multiple highly visible projects, is a creative problem
solver, and has an aptitude for learning.
______________________________________________________________________________
Areas of Expertise
Database object creation and modifications, backup/recovery, replication,
security administration, troubleshooting, performance monitoring and tuning,
database propagation, capacity planning, product evaluation, consultation with
developers on technical issues, database design, and systems analysis, creating
and maintaining DTS and SSIS, partitioning and hardware tuning, SOX and GLBA
compliance, working with outsourced resources. Subject Matter Expert in Microsoft
SQL (6.5, 7, 2000 and 2005).
Professional Experience:
JPMorgan Chase (Formally Washington Mutual (Formally PNC Mortgage Corp. of
America)), Vernon Hills, IL 60061
SQL Server DBA
11/98 Present
_____________________________________________________________________________________
Lead DBA Database Administrator Sr 07/04 Present
Responsibilities and accomplishment include the following:
Supporting 300 + SQL Server Databases on 32bit and 64bit servers across the 3
different Data Centers and multiple domains. Some databases are above 1 TB
Supporting Mission Critical SOX and GLBA applications
SQL Server 2000 and 2005 installations, configuration and security settings
for stand alone and clustered servers
Designing and supporting high availability SQL Server solutions that include
Log shipping, Replication, clustering and SAN replication
SSAS and SSRS installation, configuration and backup
SQL Server upgrades with new service packs and hot fixes
Installation and configuring Oracle client for 32 and 64 bit servers, DB2
client and 3rd party software/tools
Creating and Maintaining scheduled jobs, Maintenance plans, database native
backups and IMCEDA LiteSpeed backups
Creating and Maintaining DTS and SSIS packages
Leading the physical database tuning efforts involving large tables
partitioning and database partitioning across multiple disks.
Creating and reviewing scripts, stored procedures for new releases
Leading the transition of various SQL Server functions/tasks from version 2000
to 2005 including log shipping setup, monitoring and modifications.
Participating in hardware designs, SAN migration and SAN utilization control
effort, capacity planning for new and existing SQL Server environments and SAN
utilization
Heavily involved in troubleshooting, resolving data integrity and performance
issues. Using SQL Profiler, query Execution plans, trace flags and Perfmon to
aide in troubleshooting
Working on Data Center Consolidation and Migration activities
Coordinating with the Offshore DBA Support Team on production support issues
Providing detailed implementation plans to Offshore DBA for new releases
Documented the Standard Operating Procedures and Maintaining Operational
Handbooks
s
________________________________________________________________________
Senior DBA (Technical Specialist II) 03/01 07/04
Lead a SOX compliant project consisted of 50 + production servers( including
cluster servers and 30 test servers running SQL 7.0 and 2000 in 24x7 environment)
using transactional replication and Log Shipping.
Responsibilities and accomplishment include the following:
setting up servers, new databases and testing environments
Responsible for the Production to Development DB Refreshes based on
requirements
security and maintenance, database consistency checks
creating SQL Server tasks
installing and supporting transactional replication
planning, testing and implementing all application's upgrades
data cleanup and synchronization
backup and disaster recovery
performance tuning
capacity planning and hardware configuration
developing and maintaining project plans
participated in tuning efforts involving partitioning of the database across
multiple disks as well as strategically placing multiple databases on the same
server
participated in New Architecture migration from Compaq to IBM servers using
optimal RAID configuration
involved in reviewing third party code for performance issues using SQL
Profiler, query Execution plans and trace flags to aide in troubleshooting.
experienced with Log shipping , BCP, DTS packages
troubleshooted and resolved data integrity issues
working with client/server analyst/programmers along with Web Developers to
ensure uninterrupted system access
As a team member worked with other DBAs to ensure 24x7 support for production
databases
Worked with Microsoft and vendor on performance tuning and troubleshooting of
Microsoft SQL Server 7.0 database, Microsoft SQL Server 2000 , NT server and
Windows 2000 server.
Worked with outsourced resources
________________________________________________________________________
Database Administrator 08/99 03/01
Responsibilities and accomplishment include the following:
Participated in planning, testing and performing major upgrade of SQL Server
6.5 to 7.0 involving over 19 production databases.
Participated in Y2K analysis and planning
Supported 35 production and non production servers in different locations.
Responsible for setup and maintenance of near real-time transactional
replication environment involving multiple local and across the network sites,
involving both homogeneous and heterogeneous databases.
Provided support in production and testing environments.
Testing environments set up in and configuration.
Responsible for capacity planning
Created and modified stored procedures
________________________________________________________________________
Junior DBA 11/08 08/99
Responsibilities in Microsoft SQL Server 6.5 included monitoring Windows NT
server activity, maintaining batch and real-time scheduled tasks, creating and
maintaining databases and database devices, setting up and maintaining security,
creating and altering tables, troubleshooting various server and stored procedure
related problems. Sybase experience includes monitoring gateway activity, using
Unix commands to control gateway connections, using UNIX commands to logon to
servers.
EKS Compunet Techologies Inc, Buffalo Grove, IL
________________________________________________________________________
Software Developer 08/98 11/98
Developing application for comprehensive performance analysis of the car
dealership based on monthly financial statements. Responsibilities included
setting-up ODBC Data Source and using it for manipulating data. Major tools used:
Microsoft Visual Basic V6.0, Microsoft SQL Server 6.5, Access and Crystal
Report.
Gabriel Environmental Services, Chicago IL
________________________________________________________________________
Chemist
Computer Systems Support Specialist 11/90 08/98
Support of the company computer system. Maintenance of the System-J based SAM
system and company network. Development of the LIMS analytical software for the
company. Major tools: System-J, Visual Basic for Applications, Microsoft Access.
Kiev Leather Manufacturing
________________________________________________________________________
Chemical Engineer 05/85 03/90
Systems and Languages:
Hardware: Intel 486, 586 (Pentium) and Pentium-Pro clones and compatible,
Compaq 2500/3000/5000/5500/6000/7000 servers, IBM-350, 360, Dell, Fiber Channel
Technologies.
Operating Systems: Windows 2000, 2003, 2008 (Server and Workstation), Windows
XP, Vista
Development tools and packages:
Microsoft SQL Server 2000, 2005,RedGate,FogLight,LiteSpeed,
Microsoft SQL Server Enterprise, Clustering, Redundant Operations, Replication,
Microsoft SQL Server Reporting Services.
Some networking experience , Transact-SQL, SQL syntax, XML, Data Transformation
Education:
March 1998 - August 1998 SOLEX Computer Academy. Wheeling, Illinois.
Certificate of completion.
Advanced Data Base development with Microsoft Visual Basic (Includes Versions 5
and 6) and Oracle as primary DBMS. Reporting using Crystal Report and Oracle
Developer 2000.
September 1997 - March 1998 REBUS Computer Educational Center. Buffalo Grove,
Illinois.
Certificate of
completion.
Application development using Microsoft Visual Basic (Versions 4
And 5) and Microsoft SQL Server 6.5. Advanced GUI development techniques.
Reporting with Crystal Report.
1980 - 1985 Kiev Institute of Light Industry.
MS in Chemical Engineering.
Citizenship U.S. Citizen
References: Available upon request.
|
