Database Administrator Resume
5.00/5 (Submit Your Rating)
Jersey City, NJ
OBJECTIVE
To obtain a position as a senior Microsoft SQL Server Administrator
SKILLS
Database Services: Microsoft SQL Server 2012, 2008R2, 2008, 2005, 2000, Oracle 10g
Operating systems: Windows Server, Unix/Linux, Languages/Scripting Languages T - SQL, PowerShell, Bourne, Korn Shell
Tools: SSIS, SSRS, Visio, Erwin, Embarcadero DB Artisan
Protocols: TCP/IP
EXPERIENCE
Confidential, Flanders, NJ
Database Administrator
Responsibilities:
- Analyzed requirements for applications and specify hardware requirements
- Setup disaster recovery environments including planning and consolidating applications combining different versions of Microsoft SQL Server using both Log shipping and Disk Mirroring
- Evaluated new version of Microsoft SQL server to take advantages of new functionality
- Setup development, QA and production environments for SQL Server 2005, 2008, 2008 R2, 2012
- Created stored procedures to gather database growth information and SSRS reports to present the information
- Created a process to gather user database information for all installations of SQL Server for the purposes of security review
- Created a SSRS report used on the enterprise intranet site to provide VOC information on various products
- Provided troubleshooting, performance tuning, database modifications and overall database system monitoring for all Microsoft SQL server installations
- Designed and implemented tables and a data load process using SSIS for use in a manufacturing application
- Created a standard template for all SQL Server installations to provide consistency between systems
- Created a batch script to automate the installation of Microsoft SQL server software
- Created SSIS packages for database maintenance used when new installations of SQL Server software occur
- Created SSIS packages for loading flat files for various applications
- Provided a solution for the archiving of manufacturing information
- Participated in the database portion of an upgrade for an accounting application
- Created PowerShell scripts to monitor the availability of SQL Server services
- Installed software and provided support for Oracle 10g installations
- Create PowerShell scripts to monitor Oracle RMAN backups and Data pump exports
Confidential, Newark, NJ
Database Specialist
Responsibilities:
- Ported Access 97 application to SQL Server 2000 using Visio
- Setup development, QA and production environments for SQL Server 2000
- Created a transaction log system shipping for maintaining SQL Server 2000 production environments
- Installed and maintained Sybase database development as QA servers.
- Provided troubleshooting, performance tuning, database modifications in Sybase and Microsoft SQL Server
- Wrote and modified Korn Shell scripts that help maintain Sybase development environments.
- Provided support of Oracle 10g installations
- Designed and implemented database for in-house application used for calculating salary and bonus amounts for employees
- Designed DTS packages for importing updating and exporting data from client/server applications
- Wrote stored procedures for generating information on salary and bonuses that provide information for mainframe employee information applications
- Planned and executed a move of production and development Windows Servers.
- Provided troubleshooting, performance tuning, database modifications in Microsoft SQL Server
Confidential, Jersey City, NJ
Senior Database Administrator
Responsibilities:
- Supported Microsoft SQL Server application that enabled clients to check their stock positions
- Supported Sybase in-house application that distributed post-processed back office customer data to Confidential client brokerage firm
- Supervised two DBA’s in providing support for various in-house applications
- Planned, implemented and supported PeopleSoft financials application
Confidential, Rutherford, NJ
Database Administrator
Responsibilities:
- Provided second level support for Sybase databases installations
- Evaluated Sybase replication for use by the organization
- Helped design and implement in-house utilities for maintaining Sybase installations
Confidential, NJ
Systems Administrator
Responsibilities:
- Provided end user support for Third Party Applications
- System Administrator for Sun Unix system with 3 servers, 20 workstations, 10 diskless workstations and 25 PC’s on a heterogeneous type 3 LAN with two subnets
- Installed and setup all clients and servers on the network