Database Administrator

Summary of Qualifications:

Technical Skills Summary:

EXPERIENCE PROFILE:

Confidential

Database Administrator

• Manage the DB2, SQL Server CIG website databases in production, performances, QA, IST, and development environments.
• Perform upgrades and apply fix packs tall environments tkeep RDMS up tdate.
• Form relationships with application development teams and business analysts tgather requirements for database designs and functionality.
• Perform and execute migrations from Oracle tDB2 of major bank core applications and critical production path applications.
• Document processes and procedures for DBA team for routine processes, fix pack installations, and upgrades.
• Conduct performance testing for enterprise releases and applications before going live tproduction.
• Work with RDBMS vendors tresolve production performance issues in databases.

Confidential

Senior Database Administrator - Lead

• Manage the entire production, pre-prod, staging, and development database environments.
• Experience with SQL Server 2000, SQL Server 2005, SQL Server Reporting Services, and SQL Server Integration Services.
• Responsible for creating company database standards and policies t govern the environment and als meet audit regulations.
• Responsible for the planning and implementation of all SQL service packs and upgrades.
• Redesign the entire database code release process from development t production.
• Implemented security initiatives t secure the database schemas and data.
• Redesign the entire backup architecture and recovery process.
• Upgraded all SQL Server 2000 t SQL Server 2005.
• Evaluate and purchase third-party software t use for database management improvement within the company.
• Design and support the data warehouse effort within the company.

Confidential

Senior Database Administrator

Retail OCIS Production DBA

• Manage and monitor over 200 production Oracle databases.
• Experience with managing Oracle 8i, 9i, and 10g
• Installed, design, and configured Oracle 10g Grid Control for the Production database environment and t run metric and monitoring reports against the production databases.
• Install and configured Oracle 10g Agents on all target hosts with Oracle databases.
• Install, design, and configured Oracle 9i Data Guard using physical standby databases for our DR environment.
• Perform and design Oracle backup and recovery procedures for our current DR environment.
• Work with application development teams t deploy their code and changes t production from UAT environments.
• Experience with capacity planning for productions databases and working with UNIX administrators t get SAN allocated.
• Facilitated and planned a successful Disaster Recovery test for the Chase Home Finance production database using Oracle Grid Control t initiate the database switchover.
• Lead DBA projects t get the disaster recovery environment back int synchronization between the production and standby databases.

Enterprise Systems Production/Development DBA

• Database Administrator for 6 IBM DB2 UDB 7.2 database servers on Windows 2000 for the research and adjustments databases for Bank One. 2 of the databases are approximately 6.5 terabytes in size with a mirrored DR server and 2 have over 10 GB of data.
• Upgraded all servers t IBM UDB DB2 8.2. 1 on UNIX AIX and loaded over 6 TB of data t PROD and DR servers.
• Set up successfully all full backup and incremental backup jobs for the DB2 databases, setting the standard for using DB2 with Veritas Netbackup.
• Configure High Availability for DB2 on Windows 2000.
• Provided database administration maintenance for applications on Oracle 8i and Oracle 9i servers. Exported data, performed hot and cold backups, tablespace check for extent space.
• Install and configured FailSafe for Oracle databases on Windows server. Create jobs in Oracle Enterprise Manager t perform hot and cold backups, sync up RMAN catalog, and export databases.
• Provided database administration for applications on Microsoft SQL Server 2000. Install log shipping between Microsoft Cluster servers. Install transactional and snapshot replication between tw Microsoft Cluster servers with MSSQL 2000.
• Created daily monitoring scripts for Windows DB2 servers t monitor database performance and send daily status emails t an email account alerting the DBAs and allowing us t be proactive on our DB2 systems.
• Install and configured DB2 Replication on AIX servers. Monitor and perform maintenance on the replication environment and write scripts t help be proactive and monitoring system health checks and server status.
• Maintained and configured Oracle Fail Safe on Windows servers for 4 production databases. Configured Oracle Data Guard for 5 production databases t create a physical standby for each database. Maintain the Oracle physical standbys manually.
• Applied Oracle and DB2 patches t databases.

Confidential

Network Administrator

• Configure Cisc Catalyst 2948G switches and configure and activate ports
• Add switch ports t VLANs and trunk VLANS across stackable switches.
• Rack switches and install the base standard configuration.
• Configure firewalls and add conduits t allow different servers and applications t connect across different network domains.
• Configure router with access groups and static routes in the infrastructure and lab environment.

Confidential

Database Administrator

• Install and configure Sybase Adaptive Server Enterprise 11.9.2 on Windows NT, Sun, and HP Systems for projects.
• Install and configure Sybase Adaptive Server Enterprise 12.0 and 12.5 on Windows NT, HP and Sun Solaris Systems for development and QC environments.
• Install and configure Microsoft SQL Server 2000 on Windows 2000 Advanced Server and Veritas Clustering with MSSQL Replication for a production environment. Installed MSSQL 2000 Replication publisher and distributor for replication environment. Provide maintenance and tuning for this environment. Build and configure servers with Windows 2000 server and Advanced Server.
• Install and configure Microsoft SQL Server 7 on Windows 2000 Server and NT.
• Install and configure Sybase Replication Server 12.1 on Windows NT 4.0, UNIX Sun Systems 2.8. Created replication definitions, subscriptions for tables t replicate between Sybase servers.
• Provided maintenance and support on over 80 production database servers and 200
• development/QC database servers in the infrastructure and commercial environment.
• Work with other project teams throughout the organization t design and implement different databases architectures t supply business and customer needs.
• Perform performance maintenance and tuning on all RDBMS on infrastructure and
• commercial systems daily.
• Install and configure Microsoft SQL Replication and Sybase Replication in a
• heterogeneous replication environment t replicate data between the tw RDBMSs.
• Provided performance maintenance and monitoring of MSSQL and Sybase replication environments.
• Scheduled and monitored database optimizations and integrity maintenance jobs t run nightly on all RDBMSs for database maintenance.
• Scheduled and monitor database backups for all production and QC databases for development teams.
• Installed Oracle 8i on Sun Solaris and perform administration tasks such as creating databases and adding users.

Confidential

Business Software Consultant - Consulting

• Work on contract basis with TMI at client sites t provide technical and business expertise for implementing the Facets healthcare provider software package.
• Handle technical jobs that were required during implementation of the project.
• Configure clients Sybase database t support the Facets software application.
• Analysis on clients' current legacy system and determine the business and technical configuration strategy t meet the clients business needs t convert t the new Facets software application.
• Provided data mapping t determine what data fields where needed in the implementation of the Facets software application from old legacy systems.