| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLEPHONE NUMBER AVAILABLETechnical SkillsDatabases: Oracle 11G, 12C, and 19C, MS SQL Server 2019, 2016, 2014, 2012 EE/SE, Amazon AWS cloud services, PostgreSql.Oracle Database Tools: EXPLAIN PLAN, STATSPACK, AWR, ADDM, ASH, SQL Developer, Grid Control, SAS, Backup Utility, SQL LiteSpeed, SSIS, Toad, SSMS, PgAdminOperating Systems: Solaris 16/14/10, Sun Sparc, Linux, RHEL 5.X/4.X, OEL, HP UX 11i, Windows 2016/2019 & Windows 10R2,EducationSt. Cloud State University, St. Cloud, MinnesotaBusiness Economics/Instructional Technology(Bachelor's degree, BSc.)North Hennepin Community College, Brooklyn Park, MNBusiness Management (Associate degree, AA)Auchi Federal Polytechnic, Edo State, NigeriaComputer science (OND)SKILLSAs a Senior Database Administrator, I have over Nine years of depth experience in database administration, configuration, patching, migration, upgrades, performance tuning, backup and recovery.I am an Oracle, Microsoft SQL Server, Aurora PostgreSQL and AWS Certified Professional, and have extensive knowledge of Oracle 11g, 12c, and 19c, as well as Microsoft SQL Server 16 and 19 servers, VMware, and Amazon Web Services, PostgreSQLI worked on High Availability Projects for data scalability, performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Microsoft SQL Server Databases, Open-source DB, and Cloud Databases.Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity.Experience as 24 x 7 productions on call DBAExperienceTISTA Science and Technology Corporation(Contractor to USDA)Senior Database AdministratorOctober 2022 - PresentRemoteI coordinate with regional users and stakeholders to resolve any database issues, ensure data security and quality, and support the application software packages used by USDA, monitoring and testing.I also participated in project tasks that required database support, vendor management, cloud migration, and data replication. Worked on configuring SQL Server with minimum privileged access.Administrated a very large and complex databases in SQL Server SQL Server 2014, 2016 and 2019 both EE and SE. Experience in using SQL Server Profiler, SQL Server Agent, and Database EngineProficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning. Having hands on experience in DR processes including Log Shipping and Database Mirroring.Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agent on multiple database servers.Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.Implementing Data pump, conventional export/import utility of Oracle 12C, and 19C for re-organizing Databases/Schemas/Tables to improve the performance and data refresh.Environment: PostgreSQL 8.4.x, 9.5.x, Oracle 12C/19C, RedHat Linux, and Window serversUS Environmental Protection Agency (EPA)Region 5Senior Oracle DBAJune 2019 - PresentHybrid Chicago IL.Support and maintaining Laboratory Information Management System (LIMS Application software) utilize by region 5 Central Regional Laboratory for all EPA laboratory sample Monitoring, Testing, and ReportsEnsure availability commensurate with the criticality of the application through a variety of techniques, including upgrading the Labware LIMS, Elab LIMS, Element LIMS, (Promium) Desktop workstations.Perform all above tasks, while working on high availability project such as upgrades, database and server migration, applying quarterly bundle patches and server security patches as needed.Proficient in writing SQL queries to manage customer database, test scripts in SQL to check the data integrity from the databases SVT (System Validation and Testing)Coordinate with Regional TPOC and users for designated Database connections, resolve any user connectivity or other Oracle issues, performance turning and capacity planning.Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager)Knowledge of checking data flow through the front end to back end, using SQL queries to extract data from the database to validate it at the back end.Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLANKnowledge of data analytics and business intelligence models to interpret technical solutions being implemented and design test cases that address functional and regulatory requirements.Communicate with the team - status, issues and risks on a timely basis to mitigate and drive project issues to resolution. Assisted the team in executing the ETL workflows to its completion and monitor the results.Champion CA and the notion of minimal downtime operations, inclusive of patching and upgradesEnvironment: Oracle 11gr2, and 12C, Microsoft window server 2008, 2010, and 2012 R2, Microsoft VMware, TOAD, Promium Element Data System App. (LIMS)Great Wolf LodgeLead Snr. DBAFeb 2018 April 2019Chicago ILExpert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.Support on-premises and Cloud (OCI and AWS) databases, modified AWS instance and scaled the storage to increase space, while enhancing productivityMigrated Amazon AWS using S3 bucket and importing into MSSQL database.I have Administrated for very large and complex databases in SQL Server 2008 R2, SQL Server 2012, 2014 and 2016 both EE and SEExperience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA). implementing snapshot isolation and DDL triggers.Handled multiple SQL Instances on Cluster environment for Server Consolidation projects and High Availability. Administering four-Node cluster Active/Passive onExperience in Disaster Recovery Planning and Security Management operations.Participate in project tasks which might require database support, ranging from architecture and design discussion / project planning to solution development or implementation.Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle RAC databases.Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.Having hands on experience in DR processes including Log Shipping and Database Mirroring.Worked on configuring SQL Server with minimum privileged access.Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.Troubleshoot performance problems, fine-tuning of databases and index Analysis. Having Experience on Data center servers and handling 3.8 TB databases.Environment: Oracle 12C, 19C /RAC, VMS, Windows Server 2012/2014 and 2016 EE and SE, MSSQL Server, Amazon AWS,Tools: SSIS, SRS, SSMS, CMD, TOAD, RMAN, OE M.Sapient CorporationOracle Database AdministratorJune 2014 Nov. 2017.Remoteperformed data analysis and data profiling using complex SQL on various sources systems including Oracle and Microsoft SQL Server DatabasesStrong experience in Data warehouse concepts, SaaS, PaaS, ETL.Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.Familiar with data architecture including data ingestion pipeline design, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.Configured Golden Gate High Availability using Oracle DBFS and Active Data guard.Implemented Golden Gate Downstream Mining and Integrated components for Active-Passive and Active -Active replicationAnalysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.Developed working documents to support findings and assign specific tasks technologies such as Big Data, SQL, Shell scripting etc.Performed conversion of Single Node Instance to Multi Node RAC with ASM and adding instance to existing RAC.Worked on Automatic Storage Management (ASM) with EMC Storage for managing data in SAN.Used Azure services in deployment and development of projects. This includes using of Azure VM, Compute, Storage, App Service, SQL DatabaseSet up, configured and maintained data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.Environment: Oracle 11g/11g RAC/9i, Windows Server 2012/2014, VMS, Sun Solaris, Red Hat Linux, TOAD, RMAN, OEM. |
