SUMMARY:

• A database administrator / developer with Five plus (5+) years of IT experience in managing SQL/Oracle Server and its databases in a Production, Testing and Development Environments for Healthcare, Financial, Manufacturing and Telecommunication sectors. I possess a strong experience with configuration, implementation and maintenance of several SQL/Oracle Server versions and databases.

TECHNICAL SKILLS:

RDBMS: MS SQL Server, ORACLE 11g, 12C

Operating System: Windows, Linux, UNIX

Network Topologies: TCP/IP, DNS, WINS, DHCP, SMTP, FTP, FASP

Ticketing tool: Remedy, Service Now

Monitoring tool: CA Unified Infrastructure Management

Virtualization: VMware, AWS, Azure

ETL / Developer Tool: Oracle SQL Developer, Microsoft Visual Studio 2012/2016, Import and Export Wizard, Informatica Power center 9.6, 9.1

Performance Tools: SQL Profiler, System Monitor, Performance Monitor, Database Tuning Advisor, Index Tuning Wizard, Extended Events, IDERA (SQL Diagnostic Manager)

PROFESSIONAL EXPERIENCE:

Confidential - Holmdel, NJ

L3 Database SME

Environment: Windows Enterprise Server, PL/SQL, TSQL, Oracle 12c/11g, SQL Server, Informatica9.6.1, Linux, Unix, Remedy, CA UIM

Responsibilities:

• Work extensively with the Obsolescence and Change Management team to implement infrastructural and database structure changes.
• Maintain an open communication channel with application owners and make documentations regarding application usage/requirements to better plan for a smoother support design and configuration setting.
• Review and redesign new databases for application owners, taking necessary considerations to the use of datatypes, parameter setting and storage space growth to suit the business need
• Engage quick expertise in troubleshooting and resolution of incidents affecting critical database systems and its application users
• Provide architectural recommendations and hands on troubleshooting to optimize the performance of our production databases (like creating baselines, resolving parameter sniffing issues, proper parallelism and fill factor setting)
• Implement Server upgrades for obsolete MSSQL Servers versions to newer supported server versions, ensuring all Agent Jobs, database structure and configurations remain as scheduled and designed
• Enforce dynamic data masking to prevent developers and application users to transcribe certain columns sensitive data.
• Implement security Hardening of production databases & servers to meet SOX compliance standard
• Modify and give recommendations to developers for poorly performing Stored Procedures, Views, User Defined Functions, Triggers
• Perform routine Patching, Hot fixes and Service packs installation for SQL Server to keep our servers stable and prevent malicious attacks
• Implement row level security (RLS) to give database users specific access to rows to access from the table thereby maintaining the overall integrity of data per user.
• Configure and support the High Availability and Disaster Recovery solutions (Mirroring & Log-shipping configurations) to minimize data loss and down time for our highly critical applications
• Implement SQL Server table partitioning to manage and maintain query performance for the high volume of data which we present have in our databases.
• Participate in On-call rotation to support and troubleshoot incident during and of production hours.
• Provide support for running Workflow sessions for ETL mappings on Informatica Power Center Client tool to ensure that all critical reporting jobs mapped to the Data marts runs successfully

Confidential - Icahn Sch of Medicine, NY

Database Administrator / Developer

Environment: Windows Enterprise Server 2012, UNIX, Oracle /11g, SQL Server2016, Visual Studio 2012, Excel, Azure

Responsibilities:

• Migrated all existing databases from SQL Server 2005,2008, 2014 to SQL Server 2016 version ensuring that all user account, vital parameter settings and configurations was maintained
• Created SSIS packages to extract, transform and Load historic data from obsolete legacy system to SQL Server 2016 Data Warehouse using Visual studio 2012
• Designed Data Integration jobs with Error Handling and email notifications.
• Created Stored Procedures and Views to support Applications users using T-SQL Statements
• Designed data models for the Data warehouse and Data Marts using Visual Studio and SQL Developer Data Modeler taking precise consideration to the business process, dimensions and measured facts.
• Administered expert security support both on Server and database level to ensure the integrity of the data present in each database
• Implemented dynamic data masking to obfuscate certain table columns with sensitive patient data.
• Off loaded archival (cold) data to the Azure Cold for storage using the stretch database utility in SQL Server 2016 version.

Confidential - Edison, NJ

SQL SERVER DBA

Environment: Windows Enterprise Server 2012, SQL Server 2012, 2016, Visual Studio

Responsibilities:

• Maintained best practice and provided adequate documentation while installing SQL Server to optimize performance and implement better capacity planning strategy.
• Configured Database authentication parameters by creating users and groups with adequate permissions to satisfy the business need.
• Modelled Databases according to business requirement specifying the adequate file system usage and taking consideration to the R.T.O and R.P.O
• Created indexes on tables (Clustered, Non-Clustered, Unique, Filtered indexes) for better and faster retrieval and update of data
• Utilized the Query store feature in SQL Server 2016 version to review the query plan history of an executed query and enforced a better execution plan for the optimizer to compile the query with.
• Performed database table partitioning for efficient management of database tables and indexes.
• Configured transactional replication as a DR solution and also supported it to ensure sync and consistency in the data set.
• Implemented backup and recovery strategies to constantly secure the existing databases.
• Mirrored databases across servers in both Synchronous and Asynchronous modes for DR and HA purposes
• Implored the use of SQL Server Agent Service to and schedule jobs to automatically run backup processes, migrate data, Execute Triggers, Stored procedures and Index rebuild.
• Administered Transparent Data Encryption (TDE) procedure on some of the very sensitivity data
• Employed the use of Extended Event Session for light weight tracing for performance tuning of databases.
• Migrated and supported Critical MSSQL Server database to AWS Cloud platform using DMS service.
• Configured EC2 and RDS instance for our RDBMS installs.

Confidential - Baltimore, MD

Database Administrator

Environment: Windows Enterprise Server 2012R2, IDERA, SQL Server 2005,2008,2012/2014, Remedy

Responsibilities:

• Supported Very Large databases (VLDB), maintaining its Performance and troubleshooting with SQL native & 3rd party tools (IDERA)
• Supported Very Large databases (VLDB), maintaining its Performance and troubleshooting with SQL native & 3rd party tools (IDERA)
• Utilized IDERA precise for SQL Server to monitor the health of the Server, its databases and operating system which helped me create baselines to enforce better capacity planning.
• Utilized IDERA tool to monitor user privilege to the database and server to ensure that adequate access is audited, and the security of the existing data is maintained.
• Migrated Databases from SQL Server 2005 and SQL Server 2008 legacy application to SQL Server 2012 with deprecation of clustering and mirroring HA solutions and replace with AlwaysON solution.
• Partitioned tables to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Checked and fixed Database Health using DBCC Commands and DMVS.
• Managed Databases spread across multiple servers in Production, Development, staging & testing environments.
• Clustered Windows Servers 2012R2 Edition for SQL Server failover Clustering setup. Installed and maintained 2 Node (Active- Active) Cluster as a HA solution
• Configured and supported AlwaysON availability groups with 3 replicas to maintain High availability across all servers and replicated databases which can be readily readable on secondary replicas.
• Handled Memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows Server 2012R2 Edition.
• Automated comprehensive backup plan, messaging services on server failures, task completion and success.
• Enforced Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Created new database objects like Tables, Procedures, Indexes and Views using T-SQL Statements on Production environment for SQL Server 2005 and 2008 R2 and 2012.
• Administered database level triggers code for database consistency, integrity and security.
• Designed the backup and recovery strategies for SQL Server databases to meet SLA requirements.