Senior Database Administrator Resume
SUMMARY:
To obtain a technical position that will allow me to utilize my current skills and work with people providing opportunity for personal growth.
TECHNICAL SKILLS:
Relational Databases: SQL Server 2000/2005/2008/2012/2014 , Oracle 9i/10g/11g, Ingres II
Platforms: Windows Server 2000/2003/2008/2012 , HP UX, AIX, VMWare
Languages: SQL, T - SQL, VBScript, PSQL, Powerscript
Software: SQL Server Management Studio, SQL Enterprise Manager, Query Analyzer, Microsoft Cluster Administrator, Microsoft Visual Studio, Microsoft Office Suite, SQL Server Business Intelligence Development Studio, Microsoft Reporting Services, Oracle Enterprise Manager Console, HP Site Scope, SolarWinds, Redgate, OmniAudit, Crystal Reports
WORK EXPERIENCE:
Confidential
Senior Database Administrator
Responsibilities:
- Install and upgrade SQL Server 2008, 2012, 2014 software in the VM and physical environments.
- Install and manage SQL Server VM and physical High Availability Clusters.
- Manage capacity planning for best utilization of VM and SAN storage.
- Transfer data from legacy systems (DB and AS400) to SQL Server.
- Conversion and manipulation of data thru Integration Services packages.
- Data integration across multiple database platforms and versions of SQL Server.
- Install, configure and support SQL Reporting Services.
- Perform data manipulation using SQL and T-SQL.
- Design and implement standard SQL Maintenance
- Conduct performance tuning and capacity management.
- Create and manage objects including tables, indexes, and views.
- Monitor and tune SQL databases to maximize performance.
- Implement database security model, logins, and roles.
Confidential
Senior Database Administrator
Responsibilities:
- Lead SQL Server DBA.
- Manage SQL licensing for the virtual and physical environment. Participate in yearly MicroSoft license true ups.
- Monitor and manage performance, maintenance and backup of eighty eight SQL instances including five clustered instances.
- Manage all SQL Server database security hierarchy.
- Design, monitor and manage disaster recovery processes for all SQL instances.
- Create disaster recovery processes and documents, and complete periodic disaster recovery testing at the Philadelphia Confidential disaster recovery site.
- Provide audit information and maintain federally mandated standards for all Sarbanes Oxley databases.
- Monitoring of large multinational real time manufacturing production databases.
- Manage SQL Server table partitioning, database replication and log shipping.
- Diagnose latency issues with transactions and provide solutions to developers with performance tuning of database systems, stored procedures, and queries.
- Manage the change control process, reviewing and promoting database changes into production from the development environment.
- Perform data manipulation using SQL, T-SQL and Powershell.
- Design and implement standard SQL Maintenance and SSIS packages for all instances.
Confidential
Senior Database Administrator
Responsibilities:
- Lead SQL Server DBA
- Install, configure and upgrade SQL Server 2000, 2005, 2008 software.
- Manage capacity planning for best utilization of SAN storage.
- Monitor and manage performance, maintenance and backup of fifty six SQL instances including fourteen clustered instances.
- Manage all SQL Server database security, including establishing and implementing security framework.
- Design, monitor and manage backup processes and schedules for all SQL instances.
- Create disaster recovery processes and documents, and complete periodic disaster recovery testing at the Confidential disaster recovery site.
- Manage SQL changes through HP Service Center.
- Manage SQL database related incidents using ITEL methodology.
- Provide audit information and maintain federally mandated standards for all Sarbanes Oxley databases.
- Monitoring of highly transactional databases for bank customers and credit delivery organizations.
- Diagnose latency issues with transactions and provide solutions to developers.
- Performance tuning of database systems, stored procedures, and queries.
- Provide real time SQL security logging information for risk management.
- Install all SQL service packs in coordination vendors for third party applications.
- Monitor and schedule replication of databases to a hot recovery site.
- Create SSIS packages for data import and export.
- Review and promote database changes into production from the development environment.
- Perform data manipulation using SQL and T-SQL.
- Design and implement standard SQL Maintenance.
- Support and maintain Oracle 10g databases and servers.
Confidential
Database Administrator
Responsibilities:
- Technical lead for the Corporate Ingres DBA team resolving Ingres databases issues and creating common maintenance and backup scripts.
- Member of the SQL Server GM\NA DBA team.
- Install, configure and upgrade SQL Server 2000, 2005,2008 database software.
- Implement high availability clustered architecture in production environments utilizing Microsoft Clustering.
- Communicate and install SQL Server hot fixes and operating system patches.
- Create and maintain databases, data backup and recovery.
- Conduct performance tuning and capacity management.
- Create and manage objects including tables, indexes, and views.
- Monitor and tune SQL databases to maximize performance.
- Implement database security model, logins, and roles.
- Automate SQL server administration with SQL server jobs and VBScripts.
- Document and perform contractual disaster recovery tests.
Confidential
Systems Engineer
Responsibilities:
- Designed and implemented a database management system to automate an order fulfillment process.
Confidential
Systems Engineer
Responsibilities:
- Developed client server applications for use in the automotive industry.
Confidential
Business Relations Analyst
Responsibilities:
- Gathered end user specifications.
- Deployed end user applications
Confidential
Computer Operator
Responsibilities:
- Manage hardware and software for PDP-11 and VAX systems.