Gary Tounkara, A+, MCSE (****), MCSA (****)

Phone: 301-***-**** ac2tno@r.postjobfree.com

SUMMARY

Practical experience in designing and implementing data acquisition and analysis systems by developing, configuring and maintaining MS SQL Server (2005, 2008R2, 2012, 2014 and 2016) and Oracle 8i -11g, 12c database servers, with:

Expertise of Database storage (device/database creation) including

oTables, Records, Fields, Indexes, Triggers

oKnowledge of Transaction Logs, Checkpoints, and data recovery

Knowledge of SQL queries

oExperience of writing SQL queries (and nested queries)

oExperience with Stored Procedures, Functions

Knowledge of Data Management

oUnderstanding with Disaster Recovery (Backups, restores) procedures

oFamiliarity with Server Import/Export routines

Knowledge of Authentication & Object Permissions and security

Expertise of Replication (Transactional) and Always-ON

Expertise of database maintenance operations

oServer Alert Processing & Task Scheduling

oDatabase maintenance tasks & troubleshooting techniques

oFamiliarity w/ deadlocking & blocking

oFirst line troubleshooting techniques

oDatabase consistency checks

Knowledge of Windows and SQL Server Clustering, command line scripting

Expertise in SSIS/SSAS/SSRS

Knowledge of Azure cloud hosting

EDUCATION

DeVry University, Columbus OH- Bachelors of Science - Information Technology, 2002

TECHNICAL SKILLS

Windows servers (NT/2003/2012, 2016) security and active directory

MS Office Suite/ VBA Programming

SQL server (version : 05/R2/2012/2014, 2016)

Oracle 11g, 12c on Linux

GoldenGate Replication

Transact SQL / SQLPlus

Bath files programming

IBM ClearCase, TFS, VS

SSIS, SSAS

EXPERIENCE

Xerox/Conduent – Columbia, MD Jan 2014 – Present

System Developer Principal

Design and develop data warehouse platforms for Conduent's Transit customers for data visualization using dashboards. Design data acquisition and replication systems between OLTP and data warehouse. Design and implement data migration solution to Microsoft Azure cloud. Extract, Transform and load complex data from multiple sources using SSIS packages into usable and meaningful datasets for reporting and analysis. Support and maintain existing codebase through IBM ClearCase and Team Foundation Server (TFS) and bugs fixing. Design, develop and data quality solutions for Qlikview datasets and front end development. Develop data cubes using SSAS to improve performance for data aggregation, sorting and filtering. As the team leader, coordinate end-to-end data deployment of this BI solutions from data modeling to development and support responsibilities. Solid experience and strong understanding of operational issues and translating business solutions into applications design.

Xerox/Conduent – Columbia, MD Sep 2012 – Dec 2014

Senior Database Administrator

Maintain the production and the development of databases for 25 transportation agencies using clustered SQL and Oracle database servers. Coordinate the design, development, testing and documentation of databases through Software Change Request (SCRs).

Implement database replication and mirroring and other high availability database solutions. Evaluate new database technologies and tools; provide support for the development and maintenance of database environments with emphasis on security, availability, performance and recovery. With strong communication and troubleshooting skills, provide practical experience with replication between SQL and Oracle servers using native or Golden Gate replication on Linux 6.5.

Fine-tune databases to ensure optimal performance, identify index, trigger and stored procedures requirements and lead their development. Provide expertise in the area of physical database design, tuning, backup and recovery procedures in order to resolve database performance, capacity planning and replication or mirroring issues. Check 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 to production environments.

Provide technical support for SQL Server database environments to include installation, configuration, development, performance tuning, troubleshooting and upgrades. Design and implement transactional replication, high-safety mirroring and backup and recovery plans through command and power shell scripting for production and development environments.

Dell Inc. Sep 2011 – Mar 2012

Senior SQL server DBA

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 SSIS packages to load data warehouse and ETL processes. Performed troubleshooting of SSIS packages and data load using BCP. Ensured 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.

UN Food and Agriculture Organization (FAO) Rome, Italy Mar 2004 - Nov 2010

Operations Officer / SQL Server

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 and 2008) 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.

Anheuser-Busch Inc. Columbus, OH Sep 2000 – Nov 2003

Systems Engineer II

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.

Time Warner Communications Inc. Columbus, OH Jan 1998 - Jul 2000

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.

Others:

Speaks: French, Russian and Italian

Contact this candidate