| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
ORACLE/SQL SERVER DATABASE ADMINISTRATORPHONE NUMBER AVAILABLE EMAIL AVAILABLESUMMARYHigh-skill Oracle/SQL Server Database administrator with 8 years of experience in Oracle database version 10g, 11g, 12c, and 19c in development and production environments. With SQL Server I have explored 2008, 2012, 2014, 2017, and 2019 versions.I have proactively monitored and tuned system available resources using tools and utilities like OEM, customized scripts, AWR report, ASH, and the Explain plan SQL tuning advisor to keep the performance of database systems up and running. Possess complete SDLC knowledge with great working experience on Oracle 10g, 11g, 12c, and 19c versions.TECHNICAL ENVIRONMENTOPERATING SYSTEMS:Red Hat Linux RHEL 5.x/6.x/7.x, AIX 6.x, MS SQL SERVER, Solaris10/11and Windows 2000-20xxRDBMS:Oracle 10g/11g/12c/19cLANGUAGES:SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash ScriptingSOFTWARE/ APPLICATIONS/ TOOLS:Oracle Enterprise Manager (OEM), Oracle Data Guard, Agents, RAC, ASM, SQL Developer, TOAD, Exp/Imp, DBCA, DBUA, Recovery Manager (RMAN), DataPump (expdp/impdp), SRVCTL, AWS, SQL*Plus, Recovery catalog, Crontab, Golden Gate, Data Guard, TDE, Data Redaction, Service Now, Remedy etc.TUNING TOOLS:SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ASH, SQL TUNING ADVISOR, ADDM, ORACLE DATABASE REPLAY, SQL ACCESS ADVISOR, etcORACLE DATABASEGolden gate for replicationData Guard for disaster recoveryRAC for availabilityPerformance Tuning/AnalysisTestingAWS migrationProduction SupportOEM Grid/ cloud controlShell ScriptingMultitenant ArchitectureInstallations and ConfigurationsUpgrade and PatchesDatabase AdministrationRMAN (Recovery Manager)Data pump and export/importTransportable TablespaceAWR, ADDM, ASH, Explain planSQL TRACE, TK PROFSQL Tuning & Access AdvisorMS SQL serverBackup and recoveryUse SSMSMirroringPerformance tuningUpgrade and patchingDATABASE $ SOFTWARE SUPPORTEDOracle- 10g,11g,12c, and 19cMS SQL server- 2012,2014OPERATING SYSTEMLinux (Red Hat), Unix, Solaris, Windows, AixPROFESSIONAL EXPERIENCETaylor Farm Annapolis, MD June 2020 Sep 1st 2023Role: SQL Server Production DBAInstalls configures, and maintains Databases as per product requirements and industry best practices. Ensure that the database is available, secure, healthy, efficient, and recoverable as expected.Performing regular system reviews using Solar wins, plan and implement solutions for current and future needs.Run database maintenance as required, backup, and restore different databases.Complete the first level of analysis (CPU, memory, space, blocking sessions, failed jobs, tuning queries for performance, etc.)Create database users/logins and security groups. Make sure that all privileges are set as required.Performing database import and export of CSV files, migration, upgrade, and patching from one system to the other.Rebuilding cluster and non-cluster indexes off and online.Design and develop MSSQL automation workflows using Python and PowerShell.Import and Export CSV files from one database to another using the MSSMS Import and Export wizard.Recover tables from existing backup tables. Make sure that tables match their character sizes.Data Modeling Skills compare two different environments using the ERWIN Data Modeling tool.Migrating data from Oracle to SQL Server Environment using WinSCP.Apply MS Patch, version control, and vulnerability management as needed.Using an operating system like Linux, Unix, and Aix for creating of the database mount point and job scheduleMigrating data from one platform to the other using tools like WinSCP and SecureCRT file transfer.Making changes on batch profiles as required on a Linux operating system.Expert level of understanding of SQL Server and Oracle administration and troubleshooting.Having knowledge of High Availability implementations (e.g. Windows Failover Cluster, Always On availability groups).Excellent written and verbal communication skillsPfizer Peapack, NJ. Jan 2017May 2020Role: Oracle Database AdministratorResponsibilities:Manage all database instances across development, staging, and production environments, handling installation, configuration, and maintenance. Monitor database performance, optimize query execution, and tune database parameters to ensure optimal efficiency and responsiveness.Implement and enforce database security measures to protect sensitive data. Monitor database access, audit trails, and user privileges to ensure compliance with internal security policies, regulatory requirements, and all applicable legal requirements.Develop and implement backup and recovery strategies to protect critical data and ensure data integrity. Perform regular backups and test recovery procedures to minimize the risk of data loss.Identify and resolve database performance issues by analyzing query execution plans, tuning SQL statements, and optimizing database structures and indices. Implement performance monitoring tools and provide recommendations for enhancing system performance.Access database storage requirements and plan for future growth. Monitor database space utilization, allocate storage resources, and implement partitioning strategies to optimize storage efficiency.Implement high-availability solutions to ensure database uptime and minimize downtime. Develop and test disaster recovery plans to ensure business continuity in the event of system failures or disasters.Investigate and resolve database-related issues, including performance bottlenecks, connectivity problems, and data inconsistencies. Work closely with developers and system administrators to diagnose and troubleshoot complex database problems.Create and maintain documentation, including database schemas, configuration settings, and standard operating procedures. Prepare reports on database performance, capacity, and system health for management and stakeholders.Collaborate with other teams, including developers, system administrators, and network engineers, to ensure seamless integration and efficient database operations. Great team player.Refreshing Dev and Test instances with data from Production regularly.Provided instance-level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO, and Memory Usage.Extensive experience in RMAN recovery testing, RAC, and standalone databases.Experience in setting up Oracle ASM storage for Oracle RAC databases.Performed database replication through Golden Gate.Implemented Data Guard with high availability and performance configurations and participated in Data Guard Failover tests.Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.Worked extensively on Performance tuning by partition, indexing, use of Hints, and gathering Statistics.Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, AWR, ASH, ADDMPerforming monthly and annual performance reports for trend analysis and capacity planning.Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, droppingSupported SQL Server Databases Designed and implemented the database servers for two new data centers.Administration of large databases in SQL Server 2014 and 2016Used Execution Plan, SQL Profiler, tuning SQL query, and Database Engine Tuning Advisor to optimize queries and tune databasesCreated and managed databases, and schema objects such as tables, views, indexes, procedures, triggers, and database constraints to meet business requirements and policies and maintained referential integrity.Implemented SQL Server Security and object permission like creation of users, configuring permissions database authentication modes, and assigning roles of users.Provided 24x7 production support for SQL Server databases on Clustered Servers to achieve maximum performance and uptime in production environmentCreate and maintain all SQL Server databases required for development, testing, education, and production usage.Implemented Security through a Virtual Private Database and Fine-grained Auditing.Created users, and roles and granted privileges according to the business requirements.Education & CertificationBachelors Degree in Computer Science 2014University of BueaOracle Certified Associates (OCA 12C) 2019SQL Fundamentals 2019MS AZURE Advance certification |
