SUMMARY

Practical experience in designing and Implementing data acquisition and process control networks, built and configured and maintained MS SQL Server SQL7/2005/2008R2 - 20012 and Oracle 8i -11g servers with:

TECHNICAL SKILLS

EXPERIENCE

Confidential

Senior Database Administrator

• Maintain the production and development databases and develop procedures for the OrbCAD databases for 25 transportation agencies using clustered SQL server and Oracle databases. Coordinate the design, development, testing, documenting and implementing Software Change Request SCRs for production databases.
• Provide technical support for SQL Server database environments to include installation, configuration, administering, performance monitoring, troubleshooting and upgrading SQL Server database servers. Design and implement transactional replication, high-safety mirroring and backup and recovery plans through scripting for production and development environments.
• Fine-tune the databases to ensure optimal performance, identify index, trigger and stored procedure requirements and lead their development. Provide expertise in the area of physical database design, performance, tuning, backup and recovery procedures in order to resolve database performance, capacity planning and replication issues.
• Confirm the integrity of database backups by scheduling periodic database restores with the DBA team members at various locations and for specific applications. Perform required database backups and restores. Work closely with application developers to guarantee database availability of objects such as tables, indexes, views, and stored procedures are successfully moved from development environments to production.
• Implement database replication and mirroring and other high availability database solutions. Evaluated new database technologies and tools provide support the development and production database environments with emphasis on security, availability, performance and recovery. Strong communication and troubleshooting skills. Experience with Oracle DBA including Golden Gate replication on Linux 6.5 and PL-SQL development.

Confidential

Database Administrator

• Provided support for the administration, monitoring, and maintenance of Microsoft SQL servers SQL server 2008 R2/2012 utilized by a large government agency. Performed database servers' installation and configuration, tuning, capacity planning, health checks, backup, recovery and restoration, change management according to standards. Granted and/or revoked access privileges required to create and maintain the tables, rebuild indexes and other structures as needed to store data as directed by the customer.
• Ensured database design is optimized normalized to ensure best performance possible.
• Reviewed, optimized and developed stored procedures, triggers and functions and T-SQL with the development team. Worked with customers as needed on data warehouse and ETL processes using SSIS and BCP, as needed. Performed troubleshooting of events using SQL PROFILER.
• Supported that security controls are in compliance with internal and external audits, and regulatory requirements. Provide guidance and leadership to less-experienced personnel. Contributing to 24x7x365 staff coverage.

Confidential

Database Administrator

Provided support to all company data stored in SQL Server 2005, 2008 and R2. Worked with a team of other Database Administrators to insure that all corporate approved data requests are successfully completed in a timely, secure, reliable and professional manner. Worked with network managers and application owners to troubleshoot and resolve any issues that relate to security, to index and query optimization, connectivity, locking and/or blocking processes and deadlocks, data extraction or load, and data file and log size maintenance. Worked with other Database Administrators to research, analyze and implement new technologies that benefit the organization by cutting cost, adding automation and saving time.

Confidential

SQL Server DBA

• Provided support, including design and implementation of minor modifications and enhancements, for existing legacy software tools and applications using Windows servers. Scheduled backups of SQL servers and monitor their status, including maintaining and modifying when necessary the backup and restore procedures, and performing database recovery when required or requested. Monitored the performance of the databases server SQL server 2005, 2008 and R2 and apply corrective tuning measures as required. Reviewed data volume estimates to ensure sufficient capacity, managed database files, monitored storage space on servers, and take corrective action when required. Researched, tested and installed new releases of software, and applied hardware and software upgrades and patches, as appropriate.
• Participated in data integration projects and serve as project manager when requested. Ensured that all tasks assigned are carried out in accordance with established quality procedures and guidelines to achieve the agreed goals. Perform daily database operations and/or engineering services, including central monitoring of task execution, troubleshooting resolution of failed tasks, daily maintenance of production and QA databases.

Confidential

Systems Engineer/Database Administrator

• Supported the proper functioning of the packaging servers. Managed and reported on daily packaging system accuracy for the brewery units' cases counts, system faults and the process quality checks of production to the Senior Management team. Assisted in the design and Implementation of data acquisition and process control servers, built and configured Sybase ASE 11 12 and MS SQL database Systems SQL7 2000 servers and Oracle 8i. Supported ASE Replication servers issues, with troubleshooting experience of DSI RSI Data Replication server Interfaces on IBM M80 e-servers on AIX 4.3 operating systems. Maintained and troubleshoot data consistency, performance, security and access concurrency.
• Provided ongoing support for computer-Integrated manufacturing systems Using Allen-Bradley PLCs-Programmable Logic Controls. Provided leadership by analyzing complex situations and issues implementing, monitoring process improvements and new policy initiatives for the Information management and Retention Project. Managed and trained junior technicians in brewing and packaging processes and procedures.
• Trained departmental coordinators to build and maintain web pages on IIS server using Macromedia Dreamweaver and Active server pages ASP . Provided systems and user support, daily as well as off-hour support with 24-hour pager coverage. Winner of two Soaring Eagle Awards in 2001 and 2002.

Confidential

Network Engineer

• Handled daily support for a Fiber Optics fiber/coax modem high speed network.
• Provided technical guidance to junior staff through meetings, via telephone, fax, and email and in person regarding hardware, software implementation, performance and other systems issues. Developed a database driven web site using ASP Active server pages , HTML for scheduling and service coverage. Conducted training on technical support issues and facilitated team development and conflict resolution. Interacted with customers and answered their concerns in response to inquiries about the service.
• Handled and resolved customers' complaints by telephone by e-mail, fax, by regular mail or in person. Involved asking questions to determine the validity of a complaint offering possible solutions or providing customers with refunds, exchanges, or new offers, or discounts.