I am Chijioke Daniel, I was working with Suntrust, my role is SQL Server Database Administrator, I am having 5 yrs Exp in SQL SERVER DBA with efficient T-SQL skills, I have experience on SQL Server 2008 to the lastest edition, I have a great experience on installation and configuration of SQL SERVER versions, and also applying the patches, hot fix, services packs and RTM's accordingly, involved in upgrading on in place and side by side as per client requirement, and also Migrating the database on SQL SERVER 2008 to later editions, Solid experience on configuring and maintenance of High availability SQL Server solutions, including Log shipping, Database Mirroring, Replication(Transactional and Merge) and SQL Server Clustering., having experience on performance tuning on server level, database level and query level, Responsible for working with application developers in identifying, resolving and proactively working to prevent performance or other production impacting issues, Experience on Optimizing Code and Improving Efficiency in databases including Re-indexing, Used DBCC commands, DMVS and DMFs to troubleshoot, tune and monitor the health of Production database and SQL Server. Designed a backup and recovery solution based on the link between disk design, database layout, backup retention, database performance for efficient backup and restore, Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies.
|
|
● Configured and installed Windows server 2012-2018 and SQL server 2012 -2018 clusters.
● Set up HADR for SQL server 2012-2018 databases.
● Used SQL Profiler for troubleshooting, monitoring, and optimizing SQL Server and SQL code.
● Performed various data migration tasks for mission critical databases.
● Worked with business owners and other teams to setup and troubleshoot issues relating to replication andlog shipping.
● Collaborated with BI teams in the full development lifecycle of SQL server 2005 and 2008r2 enterprise data warehouses and report servers.
● Enhanced security control by creating user defined server roles in SQL Server 2012 for clients.
● Ensured availability of instances and databases via clustering and mirroring.
● Utilized the “partially contained database” feature of SQL server 2012 to ease migration and database refreshes for clients.
● Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
● Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
● Designed backup and recovery strategies for SQL Server databases to meet SLA requirements.
● Planned, implemented, and documented database structures and content for SQL Server databases.
● Set up and managed replication, mirroring and log shipping (SQL versions 10.0 - 14.0)
● Worked with end users to define, implement, and maintain reporting requirements.
● Configured the physical design of the database by implementing a flexible architecture compliance that suites both OLTP and data warehouse applications.
● Installed various logical database structures such as tablespaces to store application objects and rollback segments for transaction processing.
● Implemented change management controls, processes and practices to deliver quality services that increase client bottom line results.
● Engaged in various DR (Disaster Recovery) efforts with Always On, clustering, and replication.
● Managed multi-terabyte database systems. the largest of which was 9TB in a datacenter with over 80TB of data.
● Developed problem tracking applications that assigned all related system errors/problems to appropriate database and/or application personnel using 3rd-party tools (SQL Doctor and Idera).
● Performed schema changes in development instances and migration to production environment.
● Performed various data migration tasks for mission critical databases.
● Worked with business owners and other teams to setup and troubleshoot issues relating to replication and log shipping.
● Collaborated with BI teams in the full development lifecycle of SQL server 2005 and 2008r2 enterprise data warehouses and report servers.
● Enhanced security control by creating user defined server roles in SQL Server 2012 for clients.
● Ensured availability of instances and databases via clustering and mirroring.
● Utilized the “partially contained database” feature of SQL server 2012 to ease migration and database refreshes for clients.
● Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis.
● Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
● Designed backup and recovery strategies for SQL Server databases to meet SLA requirements.
● Planned, implemented, and documented database structures and content for SQL Server databases.
● Installed SQL Server instances both for production and development purposes.
● Performed backups and restores to create spaces in the disk for the safety of the database.
● Set up maintenance and security plans to keep databases functioning and safe.
● Created indexes in tables that needed index support.
● Used SQL Profiler for troubleshooting, monitoring, and optimizing SQL Server and SQL code.
● Configuring maintenance plans , data safe guarding and data intergrity
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
School Attended
Job Titles Held:
Degrees
© 2021, Bold Limited. All rights reserved.