We provide IT Staff Augmentation Services!

Dba Resume

0/5 (Submit Your Rating)

Wayne, PA

Hire Now

SUMMARY:

  • Information Technology Professional supporting the communications industry.Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler and other related monitoring/troubleshooting tools. Extensive background and experience in systems administration and software management in the development of business solutions utilizing the client/server environment in the following areas:

TECHNICAL SKILLS:

Technology and Tools: MSQL - DBA experience of 6 plus years. Linux/Unix System Administration(Red Hat ) SQL Server 2000/2005/2008/2012 Oracle 11g, 10g Shell Scripts DTS/SSIS/SSRS, ETL Jobs SQL Stored procedures Perf Mon, SQL Server Profile, Query Analyzer

PROFESSIONAL EXPERIENCE:

Confidential, Wayne PA

DBA

Responsibilities:

  • Administer and maintains of SQL server and applications in support.
  • Monthly archive of SQL
  • Monthly database refresh for Oracle database from prod to COB.
  • Create Roles and users for Oracle
  • Create alerts for tablespace.
  • Manage backups for Oracle using RMAN.
  • Duties involveregular maintenance,monitoring,performance analysis,trouble shooting,problem resolution

Confidential, Philadelphia, PA

DBA

Responsibilities:

  • Migrating all the SQL server database from 2005 and 2008/R2 Servers to 2012 Always on High availability Cluster environment.
  • Experience in performance tuning, query optimization using Performance Monitor, SQL Profiler and other related monitoring/troubleshooting tools.
  • Performance tuning of SQL server Jobs and Stored procedure.
  • Created alerts for database growth, locks and failover.
  • Administers and maintains SQL servers and applications in support of the university’s technology initiatives with an emphasis towards security and business continuity.
  • Creates and maintains reports (SSRS) and reporting systems in support of the university’s business functions.
  • Installs, configures and maintains various web-based software applications in support of academic and business functions.
  • Coordinates projects to implement application/web services or functions.

Confidential, Philadelphia, PA

System Analyst -DBA

Responsibilities:

  • Maintained web site consisting of 24 different SQL server databases used by Supply Chain Systems. Supported Confidential Supply Chain Systems by maintaining/enhancing software (system, application code and Database) and (hardware with 14 Windows 2000 servers) for 24 Databases with over 15,000 users.
  • Maintains all SQL databases required across all environments DEV, TEST, DR and PROD
  • Setup the backup and restore procedure and DR implantation plan.
  • Migrated the database from windows 2000 to SQL server 2005and then to 2008. That included web changes the DTS to SSIS conversion. Converted over 30 DTS packages to SSIS
  • Running port scans on Linux servers looking for security vulnerability and providing the fix. Making application security review and fix.
  • Responsible for bringing in different application groups into integrate the development code check and deployment process.
  • Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Mart, Payroll systems, Oracle Informix, oracle and SQL Server Databases.
  • Database cleanup and tuning to improve performances in MySQL.
  • Was a team lead for Fleet Management system that was developed in house with Informix 4GL code. This application tracked every function related to Confidential fleet from creedal to disposition of asset.
  • Setup real-time replication on Informix database servers.
  • Responsible for the timecard module to integrate time for east and west user group as well as contract work hours from the work order inputted by mechanics. Reconcile time for the mechanics and generate timesheets.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship