Sr. Database Administrator Resume Profile
NY
Summary
Sr. Database Administrator DBA with over 12 years extensive experience designing, coding, testing, developing guidelines, resolving integration issues, writing security policies, and supporting next-generation database solutions in Oracle enterprise and SQL Server environments as well as other cutting edge technologies. Proficient in an assortment of technologies, including Oracle 9i/10g,Peoplesoft 8/JD Edwards IBM DB2, Access 2007 , Sybase 11, MS SQL Server, JDBC, Apache Web Server, IIS 5.0-6.0 Java, C , Objective C, XML, VB.NET, C , GIS ArcGIS 9 , Unix and Pearl scripting, 3rd party tools: Red Gate SQL backup tools, Idera SQL Analytics, SQL Doctor, Apex tools, SQL Sentry, Windows and Linux complete list on request . DBA skills include:
|
|
Experience
Confidential Sr. Database Administrator |
- Manage Oracle and MS SQL Server database administration assignments for City of Fort Worth departments including : Municipal Courts served as lead DBA for all Municipal Court projects , Fire, Police Parks and Recreation, Traffic, Budget, Aviation, Solid Waste, Code, Finance administration, and all GIS systems.. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Specifically worked supported the CAD computer aided dispatch system for Fire and Police which was 3rd party software developed by Tri-Tech.
- Served as Sr. DBA and project lead in the completion of 80 migrations of databases as well as large scale mission critical and 24/7 applications. Provided database administration for mission-critical custom and packaged software applications
- Moved database servers to new hardware and upgraded databases from MS SQL 2000 to SQL 2005 and 2008.
- Designed, tested, implemented entire SQL Server Integration Services and SQL Server reporting Services infrastructure that included two production servers, two test servers, two development servers, and two Q and A servers.
- Developed or deployed approximately 100 custom financial and auditing reports for all departments using SQL Server Reporting Services.
- Enhanced end users' understanding of database systems as well as SSIS and SSRS by conducting pre-implementation workshops, delivering group and individual training sessions brown bags
Confidential Sr. Database Administrator |
- Responsible for design, maintenance, and optimization of all company databases. This includes writing triggers, stored procedures, Transactional-SQL. Responsible for installation and configuration of all database server software, performing database integrity checks, backup routines, restores, optimization, replication using transactional, and also log shipping in MS SQL 2000 for warm backups, security, OLTP, and OLAP On Oracle, Sybase, Pervasive SQL 2000i, MS SQL Server 2000, and MYSQL platforms.
- Key projects where I was lead:
- Developed approximately 25 custom financial and auditing reports using Crystal Reports 8 with T-SQL, MS Excel 2003 and Access 2003.
- Worked with System Administrators to troubleshoot hardware /software issues concerning database servers that serve the critical systems such as Circulation, Advertising, Classified, and Editorial on a 24/7 schedule which includes:
- Worked with development to set up database environments for business projects, development, and testing while pushing data to production.
- Installed and configured Oracle, SQL Server 7.0/2000, and Sybase ASE database servers on UNIX and Windows NT4.0/2000 server/ 2003 adv server Operating Systems along with applying the latest patches or service packs.
- Worked with the Security Administrator as DBA project lead to set up Database Security to comply with Sarbanes-Oxley IT Audits while managing user accounts, object-permissions, application permissions thought company.
- Configured database backups, maintenance, restores, performance monitoring and optimization, database integrity check jobs, disk space management, and replication for DRS on SQL Server, Oracle, and Sybase platforms.
- Worked with operations to help optimize server workload in correspondence with nightly database maintenance jobs. Database design and modification using tools such as SQL Server EM, Oracle EM, Sybase Central. Also using T-SQL and writing and modifying Triggers, Stored Procedures, DTS Packages and applying them to production after testing.
Confidential Contract Programmer /Analyst |
- Made modifications to the in-house written programs for the HR and Payroll applications to remove SSN's from all reports and replacing it with a unique employee number to make all Baptist reports HIPAA compliant.
- Maintained in-house COBOL and EASYTRIEVE applications.
- Tested applications for batch processing using JCL.
Confidential
Programmer Analyst I
- Primary responsibilities included design, development, and testing of department intranet/internet site and databases.
- Served as web developer writing HTML, Java Script, ASP, and T-SQL for internal company intranet applications using MS-Access and MS SQL 6.5 and 7.0.
- Assisted with writing development standards for department internet applications.
- Created and edited AVI files using Adobe Premier for CBT web applications and agent database lookups.
- Modified in-house software applications using Visual Interdev 6, MS SQL 6.5/7.0.
- Provided application and desktop support to sales reps for billing application Virtuoso II.
- Provided customer service to clients/customers.
- Developed in house software applications and maintained billing software
Confidential
IT Internship
- Provided some maintenance to COBOL applications. Helped develop batch test plans. Modified and maintained department MS Access 97/MS SQL Server 6.5 database.
- Assisted with network security, network management and configuration , disk space allocation, back-ups, installing, replacing and upgrading hardware