SEGUN ODEWALE

Texas instruments is a company that designs, manufactures, test and sells analog and embedded semi-conductors in markets that include industrial, automotive, personal electronics, communications and enterprise system.

• Managed over 500 databases and VLDB across multiple data centers
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and Upgrading of SQL Servers
• Migrated SQL Data from on premises to Azure SQL Database
• Responsible for setting up and maintaining High Availability and Disaster Recovery Solutions and large-scale database migrations from SQL Server 2005 to SQL Server 2012R2 and 2014/2016
• Using SSIS, building high performance data integration solutions, including extraction, transformation and load (ETL) packages for data warehousing
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs
• Responsible to provide 24x7 DBA & Production support for over 180 SQL Server databases in Production on Clustered Servers
• Involved in assisting SQL Server prime customers with Configuration, Administration, Implementation and Troubleshooting for Business workflow with Log Shipping mechanism
• Configured DR solution with Transaction Replication from Distribution Server with multiple Update table subscriptions
• Involved in Installation, Configuration and Deployment of SSRS Reports using different topologies
• Involved in Creation, Development and Deployment of SSIS packages in SQL Server 2008-19
• Performed Database Refresh tasks from production to Development and Staging Servers
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Performed Scheduled backups and restore operations with LiteSpeed 4.5
• Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
• Managed workload independently but collaborated with colleagues to complete larger scale tasks in distributed team environment.
• Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
• Created optimal technical solutions to user needs through research and in-depth system analysis.
• Developed custom database objects, stored procedures and delivered application support.
• Produced high-standard database solutions to meet stability, reliability and performance metrics.
• Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
• Tested programs and databases to identify issues and make necessary modifications.
• Designed and implemented TSQL queries for reporting and complex solution development.
• Supported multiple concurrent projects enabling delivery efficiencies and technical resolution.
• Built useful reporting deliverables to properly document analysis results and provide performance improvement feedback.

Neo Cloud Technology is an IT Consulting Company that helps to transform innovation performance for long term success. Neo cloud technology give technical support with Cloud computing, web design and development.

• Used Optimization tools such as SQL Profiler, Dynamic Management Views (DMVs) and Windows Performance Monitor for monitoring and tuning SQL Server performance
• MS SQL Server design, Development and administration using SQL Server 2005 – 2014 database environments
• Monitoring SQL health check and identifying issues and fixing them
• Used SQL Indexes for improving query performance, lower storage and maintenance cost
• Implemented Installation, Configuration and Upgrading of SQL Server
• Good experience in User Management and maintaining of databases
• Automation of administrative tasks like creating jobs and schedules, alerts using SQL Server Agent monitoring and troubleshooting jobs, event notifications using Database Mail
• Maintained server security by assigning logins, server and database roles and server permissions
• Implemented disaster prevention and recovery strategies and supported High Availability features like Clustering, Always On, Log Shipping, Database Mirroring and Replication
• Maintained database response times in 24X7 production environment and proactively generated reports
• Planned and Implemented database backup/restore and disaster recovery
• Implemented Log Shipping from Primary to Standby servers
• Created and maintained SQL objects like Tables, Views, Stored Procedure, Constraints and User defined functions
• Responsible for installing and maintaining SSIS, SSRS, and Power BI
• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
• Coordinated with project management staff on database development timelines and project scope.
• Wrote and maintained technical and functional specifications to document database intentions and requirements.
• Used tools like SQL Profiler, Fog Light, Red Gate for monitoring databases
• Tested programs and databases to identify issues and make necessary modifications.