Sign in

Sql Server Ms

Powder Springs, Georgia, United States
January 09, 2018

Contact this candidate



**** ******** ****** ***** ****** Springs, GA 30127 C: 678-***-****

Database Administrator

I am a dynamic professional with over 15 year experience in MS SQL Server Database Administration (2016,2014,2012, 2008/R2, 2005, 2000, 7.0) in Production, Development, Staging and Data Warehouse Environments; Working with OLTP and OLAP in Automotive, Financial, Non-Profit and Health business Domain. Looking for a challenging position in SQL server administration with a vibrant state of the art company where my managerial, analytical, problem solving skills and application knowledge can be utilized. The value I am bringing is not limited to my proficiency in assortment of technologies: MS SQL Server, MySQL, DB2, IDERA and SolarWinds Database Performance Analyzer, SAS, Power shell Scripts, Dbase IV, SSRS, SSIS, Excel, PowerPoint, MS Access, JDBC, Visio, Apache Web Server, Visual Basic, C, XML, Windows, Assembly Language PC & Mainframe, Dreamweaver, Crystal Report, VM, JCL, and IBM 370 .

Key Skills

Versed in Installation, Configuration, Maintenance, and Administration of SQL Server 2016/2014/2012/2008R2/2008/2005/2000/7.0, MySQL 5.5, 6.0 in standalone and clustered environments

Experienced in migration of MS SQL Server from version 7.0 to 2000, 2005, 2008, 2008R2, 2012, 2014, 2016

Highly efficient in capacity planning, troubleshooting, backup, restore and disaster recovery procedures

Knowledgeable working in Virtual Environment using VMWARE

Expert in implementing different types of Replication Models like Snapshot, Merge and Transactional per business specification

Broad experience in Maintaining High Availability using Failover Clustering, Database Mirroring, Log shipping and AlwaysOn

Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities

Extensive experience with MS SQL Server Management Studio and T-SQL in constructing tables, triggers, constrains, user defined functions UDF, views, indexes, user profiles, relational database models and data integrity

Extensive knowledge and experience in creating and scheduling of SQL Agent Jobs, alerts, maintenance plans, defragmentation of indexes and update statistics of the SQL Server Database

Broad Experience in analyzing and handling Database securities and Best Practice creating: Credentials, Server Roles, Logins, Audit, Server Audit specification and Surface Area Reduction

Superior experience detecting and troubleshooting SQL Server related CPU, RAM, I/O, Disk space and other resources contention

Superior Leadership skills and an effective communicator with excellent interpersonal skills

Strong analytical problem solving and organizational abilities. Possess a flexible and detail oriented attitude

SouthCoast Medical Group, Savannah, Georgia

Database Administrator

04/2016 – 06/2017

Analyzing and monitoring performance of assigned systems. Oversee the day-to-day operation associated with database performance across various applications (i.e. SAGE Human Resources management System (HRMS), AllScripts Electronic Medical Records EMR, Practice Management PM, Merge, RCXRules, RISMERGE, Empowertime, Electronic Health Records Prenatal (EHRPrenatal) etc.);

Assist with interface technologies and application management support/solutions of problems relating to databases, system backups and recovery procedures, as well as new implementations, upgrades, patching and configuration.

Ensuring that the databases are available, performing properly, kept secure through work with network admin team; and maintaining database and database servers in a healthy condition, including software installation, upgrades and patching, migrations, backup and recovery, performance tuning, security, monitoring, problem-solving writing and applying scripts to update the database.

Establishing the Performance and Tuning Production Support Project Delivery Assist in developing a more cohesive backup and recovery strategy for the organization. Analyze tables in the database to establish knowledge of data for accurate retrieval and use in reports and other business processes.

Helped identify any long processing queries that slow down the system

Understanding of how SQL reads/writes data to database files, parallelism, SQL fragmentation, disk and data file setups and standards, etc.

Understand and proficient with Microsoft SQL maintenance standards and the different types of backup and recovery options

Understand and proficient with SQL security Utilize available tools such as SQL, SQL Server Manager, Excel, SSIS and SSRS to provide technical feedback, and eventually reports for additional operational support/decision making.

Researches, evaluates and recommends new technologies and services related to activities associated with the role of DBA and overall improvements in operational effectiveness and efficiencies.

Assist in planning, coordinating and consulting with vendors and clients for hardware/software purchases, product services and support.

Created and aligned a stable database environment with a solid storage plan and operation.

Identified, clarified, and resolved project activity issues and risks, escalating them as needed.

Review technical documentation to verify compliance/alignment with our infrastructure; and if not aligned with our infrastructure outlined and prioritized tasks that ensured proper alignment when implemented.

Assists and provides support to technology department staff leadership and staff, as needed to ensure customer care is achieved at the highest level (e.g. additional system or services monitoring, special projects, providing internet and intranet user support, and specialized training to team members). Keep primary support personnel updated when there is a problem, if a planned down time or upgrade will impact the user community.

Communicates with and assists physicians, coworkers and all staff members in a professional and courteous manner. Provides customer service to all staff members ensuring needs are satisfied and where possible exceeds expectations.

Key projects:

Reduced very large databases Maintenance plan time 50%.

Restructured and redesigned the database subsystem and file system.

Reduced the vendor support cost 40%.

Developed and tested storage strategies and disaster-recovery Plan Company’s operational database, delivering solution that guaranteed recovery performance and high availability.

Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training manual.

Developed help desk documentation on different issues.

Established baseline for all the database and monitor databases with Idera and Solarwinds Database performance analyzer.

Developed change management process and best practice for our environment.

Troubleshooting application interfaces problems.

Developed questioners’ to formulate the Service Level Agreement (SLA) to establish and confirmed recovery point objective (RPO) and recovery time objective RTO with each data owner in the organization.

Victory International Center, Mableton, Georgia

Database Administrator

09/2010 – 03/2016

Managed MS SQL Server database administration assignments for diverse non-profit clients (RCCGNA)

Designed dynamic normalized OLTP databases with relational integrity constraints across multiple tables

Maintained SQL Scripts for creation of Database Objects

Managed Login and User: adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures

Designed the user interfaces and writing and implementing client validation scripts

Enhanced database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups

Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL profiler, SQL analyzer and SQL enterprise manager

Rebuild indexes at regular intervals for better performance

Managed a team to provide 24x7 production supports for MySQL and MS SQL Server databases on Clustered Servers with sizes ranging from 200 GB to 1 TB to achieve maximum performance and uptime in production environment

Monitored and modified performance using execution plans and Index tuning

Designed and implemented comprehensive Backup plan and disaster recovery strategies

Implemented and Scheduled Replication process for updating parallel servers

Created and modified data driven subscriptions, fine-tuning subscription execution

Created automated stored procedures for day end operations using SQL Server agent.

Worked on DTS Packages, Import and Export Wizard for transferring data from heterogeneous database (DB2, MySQL, MS Access, Text files and Excel files) to SQL Server

Optimized database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes, ensure technical and functional designs meet business requirements

Developed T-SQL query optimization and ETL strategies

Migrated SQL Server 2000/ 2005/2008/ 2008 R2 and 2012, with SSIS, SSRS and SSAS

Created Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS SSRS Packages

Key projects:

Contributed to non-profit organization 15% revenue growth by standardizing content from disparate databases, enabling follow up on donors and support staff to quickly respond to people needs

Created Web-enabled, group-scheduling system for a large non-profit organization, allowing community members and volunteers to register, view and print registration information reducing days and hours spent in preparation for the events 70% and the budget also by 50%

Developed and tested storage strategies and disaster-recovery plan for large non-profit company’s operational database, delivering solution that guaranteed recovery performance and high availability

Enhanced end users’ understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials

Designed RCCDS Database system to capture children and teachers records. Generated monthly and weekly reports report for Supply, inventory, expenses, children’s attendance, teacher’s attendance records. Designed an efficient backup procedure for the database system. Implemented proper indexing and constrains on the database to enhance Ad Hoc queries performance

Designed/developed/implemented Microsoft Access database applications for events management system, visitor management system, members’ management system, inventory management system, record audit management system, accounting operations system and report generating system. This helped streamline the record keeping and reduced manpower and stationary needs

RCCG Victory International Center, Mableton, Georgia

Senior Pastor

09/2001 – 9/2010

Senior pastor of RCCG Victory International Center Church for over 10 yrs with responsibilities in adult, young adult and children education, leadership training, small groups, and discipleship and outreach programs.

Mature creative leadership with experience in, team building, vision development, program creation and training to meet a variety of goals, along with proven ability to bring growth and innovation.

Motivational teacher and leader with consistent accolades for transformational results.

Ability to communicate effectively with individuals at all organizational levels, as well as, to quickly establish rapport with a diverse range of personalities.

Catalyst for growth and development in both the spiritual and personal lives of believers in the local church ages 1 to 85 from over 10 nations, average age of about 30 years old.

Active relationships with a variety of Christian organizations. Ordained minister with The Redeemed Christian Church of God for 10 years.

Successfully managed and over see church business with annual balance budget exceeding $300,000.00 for over 10 yrs.

I created a procedural manual for counting offering envelopes which has greatly minimized loses

Using Money counts Parson Technology and excel spreadsheet, I designed chart of accounts, generated financial statements, reconciled bank and credit card statements with account and receipts. Validate and review offering envelopes with members giving record for accuracy. Oversee budget preparation and variance analysis. Supervise employee payroll and benefits

Supervise the preparation of annual accounts

Secured a $ 770, 000.00 mortgage loan from the Bank of America to purchase the new church building.

Supervision of a team of volunteers and one full time staff

Provide support and training to volunteers

Sensitively handle confidential matters including meetings, disciplinary

Federal Reserve Bank, Atlanta, Georgia

Database Administrator

12/1996 –08/2001

Developed and Maintained MS SQL Server databases and worked with developers to provide support and guidance for application development

Created new stored procedures, schemas, user-defined functions, triggers, keys, indexes, constraints

Designed and implemented coding standards with the best practice

Created documentation and generated database object migration scripts for Y2K preparation

Constructed database models, data normalizations, data integrity and contentions management which reduced application down time and data contentions.

Designed an efficient backup procedure with best practice for the database system by automating the process

Implemented proper indexing and constraints on the database to enhance Ad Hoc queries performance

Participated in analysis, development and implementation of unique database recovery plan in response to outages

Implemented log shipping for highly stable top performing databases that exhibited high levels of security, scalability, maintainability, and reliability

Defined logical attributes and data inter-relationships, designed complex data structures to accommodate database production implementation, storage, maintenance and accessibility to enhance performance

Optimized database accessibility by developing load balancing architectures and processes to eliminate down time for backup processes

Analyzed and optimized T-SQL Query Performance on Microsoft SQL Server Using SHOWPLAN Output and Analysis. Creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS Packages

Key projects:

Developed approximately 25 custom financial and auditing reports using Crystal Reports with T-SQL, JDE Report Design Aid, MS Excel and Access

Designed (CSIS) The Check Services Information System which is a PC-based application used to replace old Cobol system, developed to work in conjunction with a central SQL server database for storage and retrieval of check processing information. Business Development, as well as Payment Services staff can use CSIS to obtain information on depositor activity, work type activity, volume trends, etc. to improve operational efficiency, as well as enhance existing or develop new products and services

Supported (IPAPS) Integrated Purchasing and Accounts Payable System, used by the Sixth District of Federal Reserve Bank). This system runs on MS SQL 2000 database which archived transaction with the triggers coding. The system helped reduce time spent to capture purchasing accounting information and generate report for auditing purpose

Supported (RPRS) Retail Payments Reprising System. RPRS is an application used to automate the reprising of check services offered by the Federal Reserve Bank to the other commercial bank

Developed (BPCD) Billing Product Code Dictionary. WEB base database used by all FRB districts. DTS technology is used move the data from various formats i.e. Excel, Text files, CSV file, Access and other databases file. Updating and Transferring data across WAN on weekly basis. I was assigned to keep the integrity of the data

Supported WINFAS) Application keeps all the fixed assets for six districts. This application Keep all equipment that depreciates

Designed and customized the security for Federal Reserved Capital Stock System Application (CSSA) used for the modification of the security functionality of MS SQL SERVER 2000 to accommodate FRB information security requirements and standards

Education & Training

Langston University (UCT), Tulsa, Oklahoma

Bachelor of Science, Major in Computer Information System

Tulsa Junior College, Tulsa, Oklahoma

Associate Degree, Major in Computer Technology


TRAINING: Windows NT, Windows 95, Windows for Workgroups 3.11, and Access 2.0/7.0




Contact this candidate