We provide IT Staff Augmentation Services!

L3 Database Sme Resume

Holmdel, NJ

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.

Hire Now