Strategic Solution Architect eager to utilize expertise in process evaluation and optimization demonstrated over 2 years of superior industry performance. Innovative and ambitious with a passion for furthering the organizational mission. Organized and motivated employee eager to apply time management and organizational skills in various environments. With 8 years SQL Server DBA experience Decisive development leader experienced with infrastructure, technical solution management and deployment processes. Reviewing proposals with a practiced eye and making useful contributions to the product development lifecycle. Good verbal and written communication skills.
Skills
Data and Systems Architecture
Virtual and Cloud Technologies
System and Network Security
Technical Documentation and Reporting
Deployment Support
Solution Optimization
Disaster Recovery Planning
Enterprise Server Design
Regulatory Compliance
Database creation
Backup and recovery
Monitoring and Performance tuning
Database Upgrade, patching and Migration
Software Installation and Maintenance
Database Backup and Recovery
Capacity Planning
Database Tuning
Job control language (JCL)
Writing queries
Continuous process improvement
Data Extraction, Transformation and Loading
Security
Data conversion and migration
Microsoft PowerShell
Data testing
Database analysis
Troubleshooting
Performance Monitoring
Database development
SAP PowerBuilder
Implementing security measures
Relational Database Management
Running backups
Data audits
Roadmap Planning and Prioritization
Network Configuration
Experience
07/2020 to Current
Azure Solutions Architect Ibm Corporation – Daytona Beach, FL,
Collaborated with designers, developers and engineers to bring technical solutions to life.
Met with non-technical stakeholders regularly and broke concepts down into relatable terms.
Managed SOW contract development, pricing and status updates.
Stayed up to date on business direction and processes.
Owned statement of work and change request contract development, construction and pricing, including status updates and communications across clients, teams and vendors.
Tracked change order requests and researched validity of claims based on contract scope, field conditions and other factors.
Spearheaded corrective action initiatives to resolve root causes.
Provided quality control to eliminate downtown and reduce corporate expenses.
Provided support for database upgrades and software deployments.
Built impeccable software solutions to organizational deficiencies and collaborated to meet end-user requirements.
Fixed malfunctions through algorithmic solutions aimed at origins of problematic coding architecture.
Analyzed software that was not performing to expectations and recommended techniques for improvements.
Implemented replacement of siloed software architecture, enhancing productivity and resulting in better client experience.
Experienced with designing, managing and developing SQL Server environment for different applications on an enterprise scale.
Installation/Configuration of SQL SERVER 2008&R2, 2012, 2014, 2016& 2017, 2019 in both UAT/DEV/PROD servers.
Perform and Monitor daily tasks such as Backups & Restore, maintenance of jobs, handling developers’ requests and user's permissions etc.
Implemented, and maintained all (HA) High Availability configurations like Log Shipping, Database Mirroring, Replication and Failover Clustering as a part of HADR Plan.
Worked with a team of database administrators to designed and implement Multisite.
Failover clustering For critical production database in different data center one on PREM and the other in AZURE for DR purposes.
Experience and very knowledgeable in setting up SQL server and always on AG for business-critical applications and databases.
Experience in troubleshooting always on failover issues, making sure replication is happening between primary and secondary replicas in the always-on setup.
I have experience working with AWS products including EC2, VPC, S3, IAM, Cognito AWS AppConfig and AWS organization
Configure listener and make sure applications are able to connect seamlessly in the event of the automatic or manual failover.
Configure/setup Server Properties like Memory Options, MAXDOP, CTOP, Database Settings etc.
Checking Database Consistency/health by using DBCC &Commands DMVs at regular intervals.
Actively participate in all phases of system development life cycle including planning and analysis, design, development, and testing.
Maintain application performance & scalability with a focus on (PTO)
Provide support for architectural designs to enhance complex subsystems like analytics engines.
Design and implement Continuity of Business solutions, data warehouse solutions for SQL Server databases including replication strategy and Active-Active and Active-Passive clustering.
Create alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.
Export/Import data from other data sources like flat files using SSIS/DTS packages.
Setup Database Security and maintain accounts and access levels by creating suitable Logins and Roles and assigning object level permissions.
Manage Disk space, Memory, and User Connections.
Schedule and monitor maintenance activities including database consistency checks and index fragmentation.
Extensively work on Performance Monitor, SQL Profiler, DMVs, DMFs and DTA to tune the databases, servers and query tuning.
Utilized the query store new feature in SQL server 2016 and 2017 troubleshooting database query performance related issues and created baselines and gaining insight into query plans.
Schedule weekly jobs and Maintenance tasks for better performance and created alerts with Database Mail SMTP.
Configure database maintenance plans for backups, re-indexing, and reorganization of indexes, cleanup history, and update statistics. relocation/migration of databases from one server to another using attach and detach database tasks or backup and restore.
Migration of MS SQL server databases to the company’s cloud infrastructure.
Analyzed and developed technical and functional specifications for databases serving up to 1000 employees.
Partnered with project management teams on development of scope and timelines.
Tested programs and databases to identify issues and make necessary modifications.
Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
Created and implemented database designs and data models.
Created scripts and processes for data integration and maintenance.
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
Implemented system enhancements to propose, design and develop solutions to fulfill requests and address problem reports.
Produced high-standard database solutions to meet stability, reliability and performance metrics.
Wrote scripts and processes for data integration and bug fixes.
Tested and modified databases to determine and correct issues.
Developed data models and database designs to plan projects.
Developed scripts to automate deployment and maintenance of public cloud resources.
Assessed organization technology infrastructure and managed cloud migration process.
Increased performance and scalability by sizing solutions to meet system workload requirements.
Developed scripts to automatically create data models from external metadata.
Migrated customers to latest virtual servers and storage technologies to improve performance.
Planned, implemented and integrated updated system-oriented projects.
Designed and delivered mission-critical infrastructure to maintain consistent availability and performance.
Built and oversaw network infrastructure comprised of various virtual products.
Implemented cloud policies, managed technology requests and maintained service availability.
Configured computing, networking and security systems within cloud environment.
Boosted cloud development by creating functions, applications and databases for users.
Selected appropriate AWS service based on compute, data or security requirements.
05/2014 to 06/2017
SQL Server Database AdministratorWells Fargo – El Paso, TX,
Tested and modified databases to determine and correct issues.
Assessed customer needs and goals through communication and system evaluations to modify existing databases for personalized customization.
Communicated with data architects, programmers and engineers to keep projects on track.
Performed quality assurance processes to support data warehouse improvements.
Wrote scripts and processes for data integration and bug fixes.
Developed scripts for index and table analysis actions.
Uploaded antivirus software to protect data from cyber threats and malware.
Developed data models and database designs to plan projects.
Monitor jobs and take bacup and recovery of data
set alerts to monitor database activities
Developed and implemented security initiatives to protect important company data.
Experience with web services (REST & SOAP, JSON & XML, etc.).
Cloud-base relational and database
Experience building ETL and data streaming solutions
Experience with data design and development using industry standard concepts, practices, and procedures while requiring limited supervision
Experienced with administering casandra database
Experienced in DB2 LUW (AIX).
Command line and GUI administrative tools
strong shell scripting
Experience in developing application using COBOL, Java, using external and native stored procedures if desirable
03/2013 to 07/2014
SQL Server Database AdministratorWells Fargo – Estero, FL,
Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
Followed standard practices for migrating changes to test and production environments and provided technology support to meet business requirements.
Designed and implemented TSQL queries for reporting and complex solution development.
Produced high-standard database solutions to meet stability, reliability and performance metrics.
Wrote scripts and processes for data integration and bug fixes.
Tested and modified databases to determine and correct issues.
Developed data models and database designs to plan projects.
Developed scripts for index and table analysis actions.
Performed quality assurance processes to support data warehouse improvements
Set up and controlled user profiles and access levels for each database segment to protect important data.
Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.
Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process.
Education and Training
Expected in 10/2010 to to
Bachelor of Science: Computer And Information Sciences Abia State University - Uturu, GPA:
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.