We provide IT Staff Augmentation Services!

Ms Sql Database Administrator Resume

Philadephia, PA

SUMMARY:

Obtain a position with a well - established organization with a stable environment where I can maximize my development and administrative abilities, utilize my mentoring skills, and be actively involved in the growth of the company leading to a lasting relationship in the IT field.

SKILLS:

  • MS SQL Server versions 6.5 to 2012
  • Pervasive SQL 2000
  • MS Office versions 7 to 2010
  • WMI Scripting
  • Windows Server versions NT to 2012
  • SSRS/SSIS
  • ActiveX Scripting
  • Configuring Windows Server Security
  • Windows Shell scripting
  • SQL
  • MySQL 5.5
  • XML
  • Business Objects Data Integrator ver 11.7
  • MS Access versions 7 to 2010
  • Writing/Troubleshooting T-SQL
  • MS Windows versions 3.1 to XP
  • Informix RDMS
  • Sybase RDMS
  • DTS
  • Q&A
  • Transact SQL
  • Server administration
  • Database programming
  • Performance and optimization techniques
  • Transactions and record locking
  • Database design
  • Relational database design
  • Database permissions
  • Database migration
  • Data analysis
  • Report creation
  • Mentoring
  • Clustering
  • Log shipping
  • Replication
  • Troubleshooting

EXPERIENCE:

MS SQL Database Administrator

Confidential, Philadephia, PA

Responsibilities:

  • Created/modified stored procedures and triggers
  • Created and maintained database security
  • Created and maintained SSIS packages for data load and extraction
  • Responsible for database code promotion between test, qa, and production environments
  • Created backup plans for databases and tested backups on periodic basis
  • Backup/Restore of production databases.
  • Set-up and monitored SQL Server Active/Passive clusters
  • Installed and configured GoldenGate for SQL on Federal Reserve/Treasury Cash System
  • Member of disaster recovery team. Performed multiple BRT tests throughout year for compliance purposes
  • Performed database architecting and SQL code review for in house created applications
  • Performed database upgrades from version 2005 to version 2012
  • Implemented transactional replication for high use databases in Research and Audit departments
  • Created data archive solution via TSQL for high use Research database
  • Responsible for performing SAFR Security lockdowns on SQL databases

MS SQL Database Administrator

Confidential, Pittsburgh, PA

Responsibilities:

  • Created/modified stored procedures and triggers
  • Created and maintained database security
  • Created and maintained SSIS packages for data load and extraction
  • Responsible for database code promotion between test, qa, and production environments
  • Backup/Restore of production databases and tested backups on periodic basis
  • Installed SQL Server Active/Passive and Active/Active clusters
  • Implemented snapshot replication and log shipping

MS SQL Database Administrator

Confidential, Cleveland, Ohio

Responsibilities:

  • Created/modified stored procedures and triggers
  • Created and maintained database security
  • Created and maintained SSIS packages for data load and extraction
  • Responsible for database code promotion between test, qa, and production environments
  • Backup/Restore of production databases.

MS SQL Database Administrator

Confidential, Pittsburgh, Pennsylvania

Responsibilities:

  • Responsible for converting MySQL databases to MS SQL 2008 databases.
  • Created/modified stored procedures and triggers
  • Created and maintained database security
  • Created and maintained SSIS packages for data load and extraction
  • Responsible for database code promotion between test, qa, and production environments

MS SQL Database Administrator

Confidential, Pittsburgh, Pennsylvania

Responsibilities:

  • Responsible for production databases, mainly RTI database and data requests for the Pittsburgh School District.
  • Write and maintain T - SQL scripts for data extraction and loading, as well as verification and troubleshooting SQL jobs and handle the backup and log-shipping of production databases.
  • Backing up of production databases.
  • Restoring of qa databases with scrubbed production data.
  • Aiding the development database administrators with various dba tasks.
  • Monitoring and troubleshooting database performance issues.
  • Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.
  • Working closely with project management and development on various projects from a database administrator capacity.
  • Setting up secure linked servers to support cross database server code.
  • Created federal, state, and end user reports using SSRS 2005.
  • Troubleshooting poor performing code using sp who2, perfmon, SQL Profiler, and Microsoft Operations Manager.
  • Comparing data and schemas between environments.
  • Setting up new SQL Server 2005 environments on stand-alone servers and dual node active-passive clusters.
  • Experimenting with AWE and PAE switches in order to allocate more memory to the SQL Server engine (in a test environment).
  • Working closely with our system administration team to spec out new database server equipment for various initiatives and projects.
  • Working with our help desk and product support teams in a Level III support capacity.

MS SQL Database ADMINISTRATOR

Confidential, Philadelphia, Pennsylvania

Responsibilities:

.

  • Responsible for 2 database redesigns and migrations to meet growing business demands including re - architecting databases both times
  • Implemented Disaster Recovery program for database availablility
  • Backing up of production databases.
  • Responsible for maintaining production databases.
  • Created and ran data loads using third party ETL product and SSIS.
  • Created and maintained client and in-house reports utilizing SSRS 2005.
  • Created and maintained end user and client reports using Crystal Reports.
  • Upgraded company created reports in Crystal to SSRS 2005.
  • Created maintenance and data retention policies and ensured company adhered to policies.
  • Maintained approximately 75 databases ranging in size from 10 MB to 750 GB.
  • Created/modified stored procedures for ease of tasks and developer needs.
  • Performed upgrade from SQL 7 to 2000 and also from 2000 to 2005.
  • Restoring of qa databases with scrubbed production data.
  • Monitoring and troubleshooting database performance issues.
  • Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.
  • Reviewing, approving, deploying, and maintaining database code designed by our in-house development team.
  • Setting up secure linked servers to support cross database server code.
  • Troubleshooting poor performing code using sp who2, perfmon, SQL Profiler, and Microsoft Operations Manager.
  • Comparing data and schemas between environments.
  • Setting up new SQL Server 2000 environments on stand alone servers (as opposed to clustered servers).
  • Setting up new SQL Server 2005 environments on stand alone servers and dual node active-passive clusters.
  • Experimenting with AWE and PAE switches in order to allocate more memory to the SQL Server engine (in a test environment).
  • Working closely with our system administration team to spec out new database server equipment for various initiatives and projects

MS SQL Database Administrator

Confidential, Mount Laurel, New Jersey

Responsibilities:

  • Responsible for all branch servers including database upgrades and maintenance.
  • Created and utilized Active/passive clusters to ensure branches were always operational.
  • Created and maintained SQL snapshot replication from back office to branch servers.
  • Backing up of production databases.
  • Restoring of qa databases with scrubbed production data.
  • Monitoring and troubleshooting database performance issues.
  • Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.
  • Working closely with project management and development on various projects from a database administrator capacity.
  • Setting up secure linked servers to support cross database server code.
  • Troubleshooting poor performing code using sp who2, perfmon, SQL Profiler, and Microsoft Operations Manager.
  • Comparing data and schemas between environments.
  • Setting up new SQL Server 2000 environments on stand alone servers (as opposed to clustered servers).
  • Experimenting with AWE and PAE switches in order to allocate more memory to the SQL Server engine (in a test environment).
  • Working closely with our system administration team to spec out new database server equipment for various initiatives and projects.
  • Setting up jobs that email daily reports of failed database jobs and log shipping synchronization to my team.
  • Working with our help desk and product support teams in a Level III support capacity.

MS SQL Database Administrator

Confidential, Reading, Pennsylvania

Responsibilities:

  • Created and maintained SQL snapshot replication from back office to branch servers.
  • Responsible for all branch servers including database upgrades and maintenance.
  • Created and utilized Active/passive clusters to ensure branches were always operational.
  • Backing up of production databases.
  • Restoring of qa databases with scrubbed production data.
  • Monitoring and troubleshooting database performance issues.
  • Deploying and maintaining successful maintenance plans (some of which include log shipping. Designing, developing, maintaining and troubleshooting DTS and SSIS packages.
  • Working closely with project management and development on various projects from a database administrator capacity.
  • Setting up secure linked servers to support cross database server code.
  • Troubleshooting poor performing code using sp who2, perfmon, SQL Profiler, and Microsoft Operations Manager.
  • Comparing data and schemas between environments.
  • Setting up new SQL Server 2000 environments on stand alone servers (as opposed to clustered servers).
  • Working with our help desk and product support teams in a Level III support capacity.

MS SQL Database Administrator

Confidential, Exton, Pennsylvania

Responsibilities:

  • Served as senior level support for call center.
  • Created and performed training curriculum for techs in call center on product line and enhancements.
  • Served as 1 of 4 members that was available for onsite client support.
  • Performed upgrade from SQL 6.5 to SQL 7.0.
  • Monitoring and troubleshooting database performance issues.
  • Designing, developing, maintaining and troubleshooting DTS and SSIS packages.
  • Working with our help desk and product support teams in a Level III support capacity.

Hire Now