Sql Server Database Administration

Deepika A

Sr Database Administration / Cloud Engineer

Phone: +1-630-***-****

Email: ************@*****.***

“Looking Only for Corp 2 Corp Jobs”

PROFESSIONAL SUMMARY:

Deepika - ************@*****.*** - 630-***-****

Senior Database Administrator with 11+ years of experience in Database Architecture, Administration, Database Security design, Data Modeling, Data Warehousing, and Business Intelligence technologies, who managed and maintained business-critical databases by installing and configuring, patching, and upgrading Oracle, SQL, and Redis databases.

Proficient with SQL Server Databases from SQL Server 2005 to SQL Server 2019 Oracle Databases from Oracle llg RAC to 19c RAC non-container(non-CDB) and container (CDB) databases, and GRID infrastructure, and Redis Databases ensuring the stability and security of the systems.

Extensive understanding of Snowflake Data on AWS and Power BI configuration and administration on Azure Cloud to provide a Data Lake environment for Data Engineers and Scientists for secure analysis.

Strong collaborator and team player with excellent communication, leadership, and expertise in analytical problem-solving and critical thinking

Mentoring team members about database builds Standards and procedures and issue resolution

Skilled at streamlining and automating processes and procedures within the team for various repeatable activities for productivity and efficiency.

Experience with designing and implementing disaster recovery and high availability strategies using technologies like Oracle Data Guard, Oracle Golden Gate, SQL Server Always On, SQL Server Database Minoring, and SQL Server Log Shipping for databases and using availability zones for Snowflake Cloud on AWS and Power BI

Implemented agile-driven project management and change management processes to ensure successful system changes with minimum downtime.

Also experienced in RDBMS database design, performance tuning, optimization, backup and recovery.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2008-2016.

Experience in Disaster Recovery Planning.

Migration experience from MS SQL Server 2008 to 2016.Along with Datacenter move.

Master in performing database files management, backup/restore, security management, Database Mirroring, data integration, data compression and synchronization.

Expertise in Oracle 19c features, including Automatic Indexing, Real Application Clusters (RAC), and Active Data Guard for high availability.

Experience with PostgreSQL advanced features such as partitioning, replication, and continuous archiving for point-in-time recovery (PITR).

Experience in monitoring and optimizing OLTP system performance, including index tuning and query optimization.

Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management,

Managing server and clients.

Extensive experience in Capacity Management and assigning storage for cloning environment.

Extensive experience in setting up Cloning environment and troubleshooting issues.

Expert in configuring/Migrating SQL server 2012 — 2016 with Always on.

Hands on experience in Metal 3.1 and Informatica 9.0/9.1 a data warehouse tools used in EDW for the ETL flow.

Expertise in automating routine database and system administration tasks using BASH, KSH, PowerShell, and Python.

Experience in Disaster Recovery Planning and Implementation, TSQL/PowerShell scripting for managing multiple tasks & automation, HADR, Replication

(Snapshot/Transactional), log Shipping, Mirroring, Transparent Data Encryption (TDE), SSIS, SSRS, DTS (Data Transform Service), Import

Export Data, Bulk Copy Program (BCP). Also supported and troubleshot Azure SQL, SQL Managed Instances.

TECHNICAL SKILLS:

RDBMS

Oracle 19c/12c/11g/10g/9i, Oracle 11g Real Application Cluster (RAC), ASM, Exadata X3-2, X4-2 Half Rack and Full Rack Clusters

Programming Languages

HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

Tools and Utilities

RMAN, OEM, TOAD, SQL*Loader, Export/Import, Data pump, Query builder, Net Backup, SQL Tuning/Access Advisor, SQL Performance Analyzer, Data Guard, Cloning, Migrations)

Languages

C, SQL, PL/SQL, UNIX/NT Shell Scripting, Awk Scripting, Perl.

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Web Technology

Web Portals, BMC Remedy, HP Quality Centre, HP Java ITO (OVO) console

Cloud Technology

AWS (Amazon Web Services), OCI (Oracle Cloud Infrastructure).

PROFESSIONAL EXPERIENCE:

Client: Bank of America, Houston, TX Nov 2022 - Present

Role: Sr Database Administration and Cloud Engineer

Responsibilities:

Migrating Oracle and SQL Server databases, to Cloud Environments (AWS and Azure)

Specialized in migrating and managing Oracle, SQL Server, and Redis databases to cloud environments (AWS and Azure), ensuring high availability and data integrity.

Implemented and maintained Redis databases, focusing on performance tuning, clustering, sharding, and replication as part of the cloud migration projects.

Provided 24x7 production database support, emphasizing Redis database optimization and high-availability strategies.

Developed and enforced security policies, contributing to the secure and compliant management of Redis caching databases in a multi-cloud environment.

Deploying and Managing AWS EC2 instances

Implementing Security Policies for AWS EC2 instances

Day-to-day 24x7 production database support (incident break/fix, change, service requests)

On-Call pager rotation

Administering ORACLE Databases Si, 9i RAC, lOg RAC, 11gRAC,12c, 18c and 19c

Performance Tuning Databases using SQL Trace, TKPR OF, Explain Plan, STATSPACK, AWR, and ADDM.

Creating primary database storage structures (tablespaces), altering, and modifying database structure according to the company's requirement as necessary, from information given by application developers

Installed, Configured Goldengate Replication, both UNI-Directional, and Bi-Directional

Creating databases, objects, roles, and privileges

Partitioned large tables to increase performance.

Proficient in designing and implementing data warehouse solutions, including dimensional modeling and ETL processes.

Experience with data warehouse technologies and platforms, such as Amazon Redshift, Snowflake, or Google BigQuery.

Expertise in automating routine database and system administration tasks using BASH, KSH, PowerShell, and Python.

Worked on power hi setup and configuration as an enterprise-wide reporting solution.

Fine-tuning of database objects and servers to ensure efficient data retrieval.

Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor.

Supervised code review of scripts and SSTS packages (2012, 2014, and 2017) or DTS packages (2012, 2014, and 2016) with developers

Advised developers in code optimization.

Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning, and optimization for SQL Server database.

Used database consistency checks using DBCC utilities.

Responsible for setting up SQL Server jobs to monitor disk space, CPU activity, and Index fragmentation.

Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.

Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

Working with Development, QA, and other teams to resolve issues.

Developed and implemented security initiatives to protect important company data.

Built database and warehouse, consolidating disparate data sources and unverified queries into a central source.

Identified databases are not reaching peak performance and determine ways to solve concerns.

Managed all levels of internal analytics practice, including ETL, database administration, report development, and integration.

Supervised all levels of internal analytics practice, including ETL, database administration, report creation, and integration.

Client: Ally Financial, Dallas, TX May 2018 - Nov 2022

Role: Sr Database Administrator

Responsibilities:

24x7 Production database and applications support Administering ORACLE Databases 9i, 10g, llg Managing multiple productions, testing, QA, and development Utility database instances.

Setup Standby databases for disaster recovery and reporting

Upgrade database from 9i to 10g, 9i & lOg databases to llg

Specialized in migrating and managing Oracle, SQL Server, and Redis databases to cloud environments (AWS and Azure), ensuring high availability and data integrity.

Implemented and maintained Redis databases, focusing on performance tuning, clustering, sharding, and replication as part of the cloud migration projects.

Provided 24x7 production database support, emphasizing Redis database optimization and high-availability strategies.

Developed and enforced security policies, contributing to the secure and compliant management of Redis caching databases in a multi-cloud environment.

Created UNIX shell scripts, and processes to extract data from various sources such as SQL Server and Oracle

Configured Oracle grid control to manage the entire database in a single centralized location.

Applied database patches using Opatch utility, building Clone instances for Development and Test teams.

Implemented centralized backup (hot) and recovery strategy for all databases using shell scripts, SQL scripts, and cron job.

Expertise in automating routine database and system administration tasks using BASH, KSH, PowerShell, and Python.

Skilled in developing data pipelines for ingestion, transformation, and aggregation of large datasets.

Knowledge of data warehouse optimization techniques for query performance and storage efficiency.

Knowledge of scaling OLTP systems to support high-volume, concurrent transactions.

Familiarity with PostgreSQL extensions and foreign data wrappers to enhance database functionality.

Cloned/Refreshed databases from the production database to test and development.

Implemented backup and recovery strategies using export/import, RMAN.

Created shell scripts and scheduled them for monitoring Oracle Databases

Performance tuning and Monitoring

Weekend on-call support and Payroll support.

Database backups using RMAN on tape and Disk.

Working with Development, QA, and other teams to support related issues.

Creating primary database storage structures (tablespaces), altering and modifying database structure according to the company's requirement as necessary, from information given by application developers

Implemented Oracle RAC with Data Guard implementation for disaster recovery.

Planning and implementing Backup and Recovery procedures (RMAN), scheduling daily backups, and performing periodic recovery tests.

SQL tuning using SQL Trace and TKPROF, explain plan and SQL Analyze. Tuning instore parameters for optimal performance and scalability

Running AWR reports to figure out bottlenecks and analyze using ADDM.

Database Maintenance and clearing of locks, cleaning of database logs, Re-indexing, Tablespace monitoring, database objects monitoring.

Experience in Replication of Oracle Databases using Logical Standby, Streams and GoldenGate

Designing and developing PL/SQL packages in the database layer, stored procedures, functions,

Querying V$ dynamic performance tables to figure out bottlenecks in throughput and Scalability.

UNIX scripting for automation of statistics collection as well as for other processes

Worked with Extensive Databases (VLDB)

Writing Shell Scripts to automate various routine jobs.

Designing the security and database access strategies & cloning databases, and partitioning tables

Creating and refreshing materialized views & performing SQL Loader jobs for data loading

Writing PL/SQL procedures for Extraction Transformation and Loading of data

Administering ORACLE Databases 10g, lOg RAC,11g & llg RAC

Writing Shell Scripts to automate various routine jobs.

Applied database patches using Opatch utility & worked on conversion from a single node to Multi-Node RAC.

Performance tuning and Monitoring using the Grid Control database.

Created shell scripts and scheduled them for monitoring Oracle Applications and Databases

The problem resolution repository is built in a custom DBA ticketing tool.

Working with Development, QA, and other teams to resolve issues.

Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.

Promoted high customer satisfaction by resolving problems with knowledgeable and friendly service.

Client: Enfusion, Phoenix AZ Sept 2016 to May 2018

Role: Oracle Database Administrator

Responsibilities:

Managed several production, test, and development instances (24x7 Support).

24 x 7 technical support, 24 x 7 during quarter and month close and weekends on-call support.

Installed, configured, and managed Oracle lOg RAC, llg RAC, and Standby databases.

Enhanced and maintained Redis caching solutions to improve application performance and data retrieval.

Participated in database design and optimization, with a focus on integrating Redis databases into the company’s data management strategy.

Applications Patch management: Patch impact analysis, patch application, and troubleshooting.

Involved in the project, which analyzes and applies quarterly Security patches (CPU).

Involved in implementing Dashboard-based Monitoring solutions by developing shell scripts and SQL scripts.

ORACLE TAR Management: Raised and monitored TARs with Oracle Corporation for issue resolutions.

Performance Tuning Databases using SQL Trace, TKPROF, Explain Plan, STATSPACK, AWR, and ADDM.

Generating trace files for problem resolution

Responsible for backup/recovery using and Performing backups and recoveries.

Ad-Hoc Technical Requests: Ad-Hoc Queries - SOX/Audit/Security.

User Maintenance (Creation, modification, and deletions).

Custom code migrations.

Familiarity with PostgreSQL extensions and foreign data wrappers to enhance database functionality.

Solid understanding of OLTP database design principles for maximum transaction throughput and minimal latency.

Proficient in designing and implementing data warehouse solutions, including dimensional modeling and ETL processes.

Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management dots.

The problem resolution repository was created to reduce issue resolution timings.

Working with Development, QA, and other teams to resolve issues.

Creating primary database storage structures (tablespaces), altering, and modifying database structure according to the company's requirement as necessary, from information given by application developers.

Creating and managing users, roles, and profiles, auditing and monitoring databases and user access

Planning and implementing a Backup strategy for databases, Scripting backups.

Planning and implementing Backup and Recovery procedures (Hot Backups and RMAN), scheduling daily backups, and performing periodic recovery tests.

Allocated system storage and plan for future storage requirements for the database

Created primary database storage structure for developers to develop and test Application.

Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine-tuned SQL.

Loader performance using Direct load mechanism.

Estimating space requirements for database growth for the next 12 months and availability of hardware to support processes.

Developing, Implementing, and administering database policies and procedures

Client: Novartis, Hyderabad, India June 2011 - Mar 2016

Role: Database Administrator

Responsibilities:

Responsible for installing, upgrading, and configuring the Oracle server.

Supported different Oracle lOg and Oracle 9i Databases of Production, Testing, Staging, and Training

Involved in logical and physical data modeling and schema design using the Erwin tool.

Created database manually.

Upgrade database from 9i to 1Og.

Developed PL/SQL packages, stored procedures, functions, Cursors, triggers.

Creating databases, objects, roles, and privileges

Partitioned large tables to increase performance.

Responsible for Data load on different databases using SQL Loader

Export and import of database objects using EXP and IMP Utilities

Table partitioning to improve I/O access.

Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.

Experience with PostgreSQL advanced features such as partitioning, replication, and continuous archiving for point-in-time recovery (PITR).

Using database-level triggers code for database consistency, integrity, and security.

Involved in database design, installation, creation of various instances, and creation of tables, granting roles to

users, and maintaining security according to application.

Implemented 4 Node RAC on Linux

Worked on performance and tuning of SQL queries.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas, etc.

Efficient in using Oracle Tools like SQL Plus, SQL, IMPORT/EXPORT, DataPump, and RMAN

Managing tablespaces, user profiles, indexes, storage parameters

Proficient in designing and implementing data warehouse solutions, including dimensional modeling and ETL processes.

Develop table structures, PL SQL stored procedures and database triggers to implement.

Responsible for providing 24 x 7 database administrative activities over different database servers.

Education:

Bachelor of Computer Application from Guru Nanak Girls College, India - 2008

Master of Computer Application from IIMT College of Engineering, India - 2011

Contact this candidate