SUMMARY:

Database administrator (DBA) with extensive experience implementing, testing and supporting business critical database solutions in SQL Server enterprise and DB2 for z/os environments. Proficient in documentation, interpersonal communications and teamwork to provide the best possible experience for end users. Works well under high pressure situations and thrives when in a crisis. A loyal employee with a strong work ethic and an unyielding desire to learn new technologies and develop new skills.

TECHNICAL EXPERIENCE:

Confidential, Memphis, TN

Database Administrator

Responsibilities:

• Perform all data base administration assignments for large, diverse school district.
• Enhance database performance, perform restores, implement recovery procedures, provide object security, handle performance tuning and conduct regular system backups.
• Work with development teams to ensure technical and functional designs meet business requirements.

Microsoft SQL Server Systems and software: SQL Server Skills:

• MS SQL Server 2000, 2005, 2008, 2012 Performance Tuning/Monitoring
• T - SQL Indexing (Clustered and Non Clustered)
• DTS Foreign Keys
• SSIS Database Backup and Restore
• SQL Profiler Database Security Design and Setup
• MS Project Database Design and Implementation
• Windows Server 2000, 2003, 2008 Clustering of Database Engine and
• IIS Integration Services
• Create Views
• SSIS/DTS usage for importing and exporting
• Database replication
• Data warehouse data mart administrator
• ODBC connectivity

Confidential, Memphis, TN

Systems Analyst

Responsibilities:

• Serve as DBA for large, complex student management system ( Confidential ). Responsible for all aspects of bi-annual software upgrades to base system, teacher’s grade book, parent’s portal and peripheral support software including web servers and application servers. Supported application developer’s group with customized scripts and reporting by creating objects (tables, views, logins, ODBC connections), backup and restoring databases and deployment of SSIS packages, stored procedures and jobs into production. Serve an end user community of nearly 10,000 people including teachers, parents, school administrators, executive staff, and student management staff. Monitor performance issues with Microsoft Performance Monitor and SQL Profiler. Also worked very closely with the vendor support team on reported issues.
• Provide support for Horizon Analytical financial school site based budgeting software. I have been able to maintain and mange this system even after vendor support was lost in 2009 therefore saving the district the cost associated with purchasing new software.
• Given role as data mart administrator on a new data warehouse system for the consolidated school district. Responsible for the successful promotion of SQL objects such as SSIS packages, SSRS reports and stored procedures from development, to quality assurance, to production. Also responsible for the successful completion of nightly data loads from the core systems providing input. Responsible for loading student assessment data from EXCEL into SQL tables using the import function. Creating maintenance plans for backup and recovery. Work with developers in creating extracts used in the ETL process as well as closely working with the vendor in the implementation process.
• Provide support to development and consultant team in large ERP conversion for consolidated school district. Installed SQL server software in multiple environments and provided access to financial data on alternative platform. Work with development team to successfully import data from old system into the new. Create maintenance plans for backup and recovery. Participate in disaster recovery planning and disaster drills. Currently planning for transition from vendor support to our local support team.
• Provide DBA services and Perl script execution for enterprise wide change management and service request system(Footprints)

IBM Z/OS System software: DB2 Skills:

• DB2 for Z/OS 2.3, 5.0, 7.0, 9.0 Database Design and Implementation
• QMF Indexing
• SPUFI Referential Integrity
• DDF Table space Backup and Recovery
• Mainview for DB2 (BMC Software) Runstats Utility
• DBAXPERT (Compuware) Table space reorgs
• File Aid for DB2 (Compuware) DASD Space calculations and file placement
• CA1, CA7 Table space compression
• IMS Database Security Design and Setup
• Confidential Create Views
• JES2 Database engine and support software
• SDSF installation
• TSO
• Confidential
• SMPE

Confidential, Memphis, TN

Systems Analyst

Responsibilities:

• Serve as the only DB2 DBA for Confidential since 1991. Supported multiple in house written applications including a student management system, inventory control, plant operations, travel authorization, staff development, school location and cafeteria management. Responsible for all aspects of DB2 including installation using SMPE down to 24/7 online and batch support. Provided support for development team by consulting, creating database an all associated objects.
• Support district financial system conversion from Confidential to DB2. A 12 month project culminating in a more comprehensive, user friendly system with enhanced reporting capabilities. Provide support for vendors and contractors that were writing custom reports for budget center managers and financial executive staff members.
• Support development staff for an in house written student management system. This system was converted from an IMS database to DB2 with Confidential as the online transaction manager. Provide backup and recovery, data transfers between development and production, performance tuning, support QMF ad hoc reporting and nightly batch processing. Responsible for successful promotion into a production environment.
• Assumed support role for legacy IMS databases. Responsible for software installation, Confidential online access, batch processing, data base engine troubleshooting.
• Support a web based procurement system with a DB2 for Z/OS back end. This system requires a multi-platform solution including DB2 UDB on Windows, DB2 Connect, Websphere for Windows and JDBC connections to the mainframe using DDF. Charged with maintaining and tuning extremely complex SQL queries for use by executive staff, procurement services staff, and outside vendors.

Confidential, Memphis, TN

Systems Analyst

Responsibilities:

• Performed all aspects of production batch processing, including assuring completion of job schedule, completion of printing and report distribution, problem resolution, give daily status reports to data center manager.