Sql Developer Database Administrator

Samson Oluwasogo Fadahunsi

Samson Oluwasogo

Fadahunsi

(C) 347-***-****

************@*****.***

Database Administrator &

SQL Developer

Professional Summary

Highly skilled Database Administrator and SQL Developer with 6+ years of I.T experience including inputting, configuration, troubleshooting, and maintenance of Database. Extensive knowledge and experience

managing projects including implementation and

lifecycle maintenance.

Excellent team player, quick learner, and goal-

oriented, with a strong drive for performance, success, and continuous self-improvement.

Technical Skills

Operating Systems/Platforms:

Linux (RedHat, CentOS)

Windows 7/8/10, Windows Server 2000,

Windows Server 2003, Windows Server

2008, 2012,2016,2019

Applications/Packages:

Oracle database SSL, SQL, WinSCP, Microsoft Office, Putty, SSMS, Vsphere, Jira, Confluence, PhpMyAdmin, MySql, Netcool, Solarwind, OpenNMS, ServiceNow,

Autosys, Appworx, Toad, Ansible, Qzdesktop, Sparck, Jadelogger, Sandra Monitor, Bitbucket & DB2, Luw Bob Monitor, DB browser, Hugs Monitor, Amps Browser,

QzDev, Conflict Resolver.

Language:

Samson Oluwasogo Fadahunsi

Bash Scripting

SQL

Education

Bachelor of Science: Computer Science Science

Polytechnic Ibadan, Nigeria

2001 – 2005

SQL Developer

Conduent. New Jersey Transit

January 2019-Present

Responsibilities:

• Create SQL scripts that will fulfill the user requests and submit the scripts to the DBAs for execution.

• Set up automated processes, when required, for handover to the Deployment team.

• Development of high-quality database solutions.

• Review and interpret ongoing business report requirements.

• Research required data.

• Build appropriate and useful reporting deliverables.

• Analyze existing SQL queries for performance improvements.

• Suggest new queries.

• Develop procedures and scripts for data migration.

• Provide timely scheduled management reporting.

• Investigate exceptions.

• Keep records of all scripts and queries associated with each request.

• Identify frequently submitted requests, research potential solutions, and implement the solutions to

• minimize future errors.

Samson Oluwasogo Fadahunsi

• Monitor the internal ticketing system as well as executive requests through email.

• Interpret and understand user requests.

• Research the requests and acquire additional information from the users if necessary.

• Design, develop and maintain SQL applications/ETL, databases, reports, and programs.

• Create, document, and implement test plans.

• Set up and maintain automated SQL scheduled tasks.

• Investigate and provide support to the business regarding all data- related issues.

• Designing, building, and maintaining efficient, reusable, and reliable code.

• Document current or new processes.

• Ensure the best possible performance and maintain the quality and responsiveness of applications.

• Perform data analysis – write relational and multi-dimensional database queries.

• Handle escalations from the business.

• Handle Bitbucket, And DB2 LUW

SQL Developer

Bristol Myers Squibb

FEB 2016- JAN 2019

Responsibilities and Duties:

Samson Oluwasogo Fadahunsi

o Will create and maintain reports using Crystal, Microsoft Reporting Services and SQL Reporting. Worked with the developers and/or end users to create requirements and specifications. Upon development, will submit sample reports to business owners for approval and acceptance of the final product.

o Responsible for maintaining strict testing requirements and procedures.

o Asked to optimize reports for performance and re-usability. o Documenting all aspects of the report development process. Including requirements, data and performance testing and deployment. Responsible for reviewing and implementing report changes and updates as defined by State reporting requirements (e.g., Performance Measures, Monthly Monitoring Reports, etc.)

o Responsible for working with business owners and internal and external groups to understand requirements and develop solutions to complex reporting needs, as well as addressing any reporting errors or issues after live system implementation.

o Develop SQL databases and applications to interface with SQL databases. Determine the most efficient stored procedures, views, and functions for the application.

o Troubleshooting databases and applications involving data validation and testing.

o Design and code database tables and indexes

o Review query performance and optimize coding

o Optimize existing queries to increase performance. Samson Oluwasogo Fadahunsi

o Work as a team member with other technical staff to ensure data integrity and industry reporting standards.

o Manage tickets through the help desk system that are assigned to employee.

Contact this candidate