Sql Server Customer Service
Resume:
Adeniyi Adewunmi
Jonesboro, Ga.**238
Email: **********@*****.***
Summary
Over 5 years experience utilizing computers in business as a problem solving tool. Work experience stems from database management systems to telecommunication applications. Relational Database Management Systems, Systems Analysis and Design, Network Support, Software Engineering Project Management, Systems Implementation
Languages
Visual Basic; Java Scripts; SQL; PL/SQL; XML; HTML; XSLT; Unix Shell Scripts; Batch Scripting
Relational Databases
Oracle 9i
Oracle 10g
Oracle 11g
SQL Server 2000
2005 2008R2
MS ACCESS
Applications
Microsoft Project
Microsoft Word
Microsoft Excel
MS PowerPoint
Visio 2000
Outlook
Operating Systems
Unix (AIX)
Linux Red Hat
Windows 95/98/NT
Windows 2000 Server
Windows 2003 Server
DOS
Licenses:
Sierra Academy of Aeronautics: Oakland, CA Commercial Pilot Single and Multiple-engine Land Instruments; 1987
Flight Engineer: Turbo Jet Powered; 1989
Industry Certifications:
Oracle 10g
Oracle 11g
Quality Assurance
Information Technology
Networking Certificate
Cisco Network Support
Project Management
Education :
California State University Hayward
May 2004
Bachelor of Science:
Business Administration
Concentration:
New Ventures and Small Business Management
Merritt College Oakland
California
June 2001
Associate of Science:
Computer Information Systems
Skills :
• Experience writing, debugging, and tuning Transactional SQL, and SSIS stored procedures
• Provide SQL Server database physical model creation and implementation (data type, indexing, table design)
• Experience with setup and administration of SQL Server Database Security environments using Profiles, database Privileges and Roles.
• SQL Server Replication and Data Migration
• Ability to ensure the technical integrity of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies
• Responsible for troubleshooting and problem solving of SQL Server
• Responsible for improvement and maintenance of the databases to include release rollout and upgrades
• Database administration including installation, configuration, upgrades, capacity planning, high availability solutions, performance tuning, backup and recovery in managing clusters of SQL servers
• Maintenance and tuning of the databases and replication.
WORK EXPERIENCE
Metcore Technologies: SQL SERVER DBA, 2009-Present
• Use SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code
• Perform DBA duties including: database backups, restores, performance tuning, and capacity analysis
• Generate the weekly, monthly, and quarterly report by using SQL Reporting Services
• Develop, modify, and optimize complex stored procedures, triggers to handle complex business rules and history data
Manage the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and SSIS packages.
• Design and implement SQL Server 2005 databases for mission-critical business
• Troubleshoot databases and custom application issues
• Create stored procedures, advanced queries, triggers, views, indexes, and functions for databases.
• Work with end users to define, implement, and maintain their reporting requirements.
• Participate and coordinate the creation, modification and maintenance of database structures with minimal supervision.
• Assist in the design, coding, testing and implementation of SQL databases instances
• Write, evaluate and optimize complex SQL codes, stored procedures and scripts for maintenance and reporting purposes
• Manage database users and security: Assigning users to data bases and determining the proper security level for each use; also assign permission to the various database objects such as, Tables, Views, and stored procedures
• Develop and document SQL coding guidelines.
• Demonstrate an understanding of database internals and application database components (e.g. triggers, functions, packages)
Core Technology Solutions: Database Administrator 2005-2009
• Assisted in promotion of database related changes from development to production.
• Worked with operational DBA's in the recovery of corrupted databases, timely troubleshooting of all database-related problems and emergency response to all development, testing, and production downtime events.
• Monitored application and database performance, and adjusted database parameters, application code or schema as needed.
• Monitored space usage, and adjust database as needed.
• Monitored backup operations, and schedules manual backups as needed.
• Provided technical expertise and supervision in performing and supervising the design, implementation, and maintenance of relational database management systems (RDBMSs) that supported business applications.
• Ensured logical data models are mapped effectively and efficiently into physical data models that take advantage of the characteristics of the specific database management system used. Managed resources and schedule requirements, oversees the production of all required deliverables Provides technical leadership to the business unit clients across business-specific technology domains.
Implemented and maintained best practices for operational support of a multi-platform database environment.
• Created and maintained a strong set of management and technical metrics to measure and report performance of the organization.
• Developed and implemented staffing strategies, tools, and processes in support of defined roles and responsibilities for the DBA organization.
• Delivered overall management and successful, on-time completion of client’s database system projects which include database installations and upgrades, creation of database instances and objects, performance monitoring, troubleshooting, tuning, security policies, backup and recovery.
• Acted as liaison with both vendors, internal and external customers as necessary to insure excellent customer service.
• Worked with project teams to develop database requirements and translate them into detailed specifications.
• Identified opportunities for process and database system improvements.
• Monitored trends and potential opportunities that may affect database environment.
TRAINING COURSES COMPLETED
IMPLEMENTING AND MAINTAINING SQL SERVER
• Creating Databases and Database Files, Creating Data Types and Tables.
• Creating and Tuning Indexes, Implementing Data Integrity by Using Constraints and Triggers.
• Using XML, Implementing Views, Stored Procedures and Functions
• Managed Code in the Database, Transactions and Locks.
• Using Service Broker
• Installing and Configuring SQL Server, Managing Databases Files
• Disaster Recovery, Managing Security and Transferring Data. Automating Administrative Tasks and Implementing Replication
• Maintaining High Availability, Monitoring SQL Server, Troubleshooting and Performance Tuning.
Contact this candidate