Sql Server Ms
Resume:
KORE AKINDELE
**** ******** ****** ***** ****** 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
MICROSOFT
TRAINING: Windows NT, Windows 95, Windows for Workgroups 3.11, and Access 2.0/7.0
CERTIFICATION: MICROSOFT CERTIFIED APPLICATION DEVELOPER
PROFESSIONAL
MEMBER: ASSOCIATION OF INFORMATION TECHNOLOGY PROFESSIONALS
Contact this candidate