SUMMARY

• Oracle Database administrator, Developer with over 4+ years of diversified data processing experience in Data Design, Data molding, data profiling, data quality, and DB Development. Extensive experience in Data immigration, Data Loading, Database Modeling, Data Mapping, ETL processes and Performance Tuning.
• 3+ years experience using MS SQL Server 2018, extensively worked on data extraction, transformation, and loading data from various sources like Oracle, SQL Server, and flat files. Develop, implement, administrate
• Involved in entire life cycle of the project (SDLC). Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes, OLAP.
• Experience includes MS SQL Server, T - SQL tuning & optimization, database installation, configuration, creation, database monitoring,
• Oracle utilities (Export and Import), shell scripting to perform database routine monitoring, patching, and backups.
• Experience working in complex mix environment and various platforms include VM, SQL Server, Oracle, upgrade procedures. Working experience in production, and development environment.
• Experience opening, closing, copying, importing and exporting, used utilities like SQL *Loader, Export/Import, PL/SQL tables, Dynamic SQL, oracle supplied packages for loading, immigrate data and flat files and other sources.
• Extensively worked on Functions, Procedures and Triggers.
• Used External tables to load data from external files.
• Experience in debugging for Extraction, Transformation and Loading processes.
• Data modeling and design with documentation, ER Diagrams, MS Visio.
• Excellent analytical skills, logical reasoning, interpersonal skills, attitude to lead and leadership skills to work in team environment. Excellent communications skills, fast & enthusiastic learner, excellent work ethics and a good team player.
• Equipped with an excellent work ethic, possess strong sense of responsibility and integrity.
• Great attention to detail, proven ability to work efficiently and organized in fast paced work environment
• Created shell scripts and updated the scripts as per the requirement.
• Implement, maintain and test Disaster Recovery methodology for all production databases.
• Work with application owners and technical architect’s requirements and support needs.
• Implement database security including password management, encryption, and DB auditing.
• Maintain and publish documentation for Mediacom-specific needs.
• Attend meetings with application teams and external product and services vendors.

TECHNICAL SKILLS

Operating Systems: SUN Solaris v5.8/5.6, LINUX RHL, Windows Vista/XP/2000/NT 4.0/98/95.

RDBMS: Oracle 11g Oracle, Oracle 12c, MS SQL Server

Languages: T-SQL, SQL, PL/SQL, RMAN, UNIX Shell Scripting.

Oracle Utilities: SQL *PLUS, SQL *Loader, PL/SQL, import, export, datapump, Oracle SQL Developer, MS SQL Developer, SSRS.

ETL Tools: SQL*Loader, SSIS

PROFESSIONAL EXPERIENCE

Confidential

Database Admin

Responsibilities:

• Install, configure, upgrade, migrate and patch Oracle 12c, Oracle 19c, and SQL Server databases, on UNIX and Red Hat Linux. Work at OS level on Linux, writing scripts and configuring storage.
• Created shell scripts and updated the scripts as per the requirement.
• Load high volume data and Performance tuning.
• Performance Tuning and optimization using, EXPLAIN PLAN, tkprof, various types of hints, partitioning methodologies, indexes, and oracle supplied packages DBMS SQLTUNE, DBMS PROFILER, DBMS STATS, DBMS XPLAN.
• Monitor system performance using ASH, AWR reports, writing batch programs using, scheduler features to create automatic monitoring and management processes.
• Developed scripts for inbound and outbound of the data on servers.
• Supported all the UNIX requests for various applications.
• Extensive space allocation to various applications upon requirement, detaching and clearing the devices if not in use.
• Install, configure, upgrade, migrate and patch, SQL Server, and Oracle database on Linux environment.
• Implement, maintain and test Disaster Recovery methodology for all production databases.
• Work with application owners and technical architect’s requirements and support needs.
• Implement database security including password management, encryption, and DB auditing.
• Maintain and publish documentation for Mediacom-specific needs.
• Maintain Data Design, Data molding, data profiling, data quality, and DB Development
• Attend meetings with application teams and external product and services vendors.
• Run and update RFC methodologies.
• Involved with business users for gathering and analyzing requirements, logical and physical design of the applications.
• Create, develop, SSRS, SSIS to Develop different type of reports including Cost Rollup Report, Expenditure Chart, Cost Summary Report, Funding Report, Project STD report (Spend to Day), Charge Point Repot, Pan Rollup Report, Client Contact Report, Accounting Statement Report, Employee Enrollment account (Direct and Indirect) summary report and other. Create/schedule packages, export/import data.
• Create and deploy SSRS financial report. Create tables, import and update date, create the data set using visual studio, add data set and create the sql queries, update report requirements and deploy the report at SharePoint.
• Work with business, business analysis, and system administrator on configuration the tools and report requirement.
• Attend client meeting and discussions collect requirement.

Confidential

Jr. Database Administrator

Responsibilities:

• Install, configure and upgrade the database and servers to suit the database needs.
• Design automated systems to mine information and make reports
• Provide inputs for developing newer versions of databases customized to peculiar needs. Include objects in database like tables, views, functions, triggers, etc.
• Control the access for database by controlling privileges and permissions.
• Wrote sequences for automatic generation of unique keys to support primary and foreign keys constraints in data conversions.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Created shell scripts and updated the scripts as per the requirement.
• Developed scripts for inbound and outbound of the data on servers.
• Supported all the UNIX requests for various applications.
• Attend meetings with vendors, application team, external product
• Created the design documents based on user requirements.
• Per user requirements loaded the data into dimension tables for reporting requirements.
• Develop operational plan for ETL, Data loading and data cleaning process and wrote scripts for automation using shell scripting.
• Experience with Star Schema Modeling and Snowflake Dimensional modeling
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Written complex SQL queries and PL/SQL procedures/packages to extract and process data from various source tables of data warehouse.

Confidential

Jr. Database administrator

Responsibilities:

• Responsible to develop and maintain the databases.
• Build up the database architecture and models.
• Design the schemes, permissions and tables for database as appropriate for its use.
• Install, configure and upgrade the server to suit the database needs.
• Design automated systems to mine information and make reports
• Created shell scripts and updated the scripts as per the requirement.
• Developed scripts for inbound and outbound of the data on servers.
• Provide inputs for developing newer versions of databases customized to peculiar needs, Include objects in database like tables, views, functions, triggers, etc.
• Control the access for database by assigning privileges and permissions.
• Wrote sequences for automatic generation of unique keys to support primary and foreign keys constraints in data conversions.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Tuning long running SQL queries using CBO hints, explain plan, TKPROF and Auto trace. Used DBMS STATS package and ANALYZE to generate statistics for CBO.
• Involved in writing complex scripts for Data Transformation, ETL process (Extract, Transform & Load)
• Used SQL *PLUS to generate and format ad-hoc reports
• Create various UNIX scripts for enhancing loading process and techniques for restartability of jobs
• Used UNIX Shell scripts (KORN Shell) for Extracting and Parsing data from the files.

Confidential, Denver CO

Help Desk Technician, Jr. SQL Server DBA

Responsibilities:

• Automated the installation of software to 1200 end-user PCs via DOS batch files, Symantec Basic scripting, and Novell Application Launcher snapshot technology.
• Provided second level support to internal Help Desk to resolve user concerns with specific applications, including Windows 95, Microsoft Office, GroupWise, and numerous industry specific applications.
• Supported all the UNIX requests for various applications.
• Identified and implemented technologies and methods of using existing technology to help users work more efficiently, including:
• Creating/revising and spreadsheets in Excel, and VBA programming.
• Prepared documentation and materials, coordinated technology related .
• Participated in conversion of 1200 PCs from Windows 3.1 to Windows 95.
• Assisted in deploying Help Desk, including software selection and development of procedures Worked on the Help Desk to provide support for software, printing, and network access issues.
• Work with programming staff on database design changes to meet business requirements.
• Implemented SQL Server based solution to consolidate dozens of scientific data collection and reporting applications.
• Collaborated with faculty member, scientist and staff to design data intensive applications to capture, organize, analyze and report on data collected from scientific experiments and external sources.
• Performed day to day DBA activities such as monitoring SQL Server health, job status, addressing user requirements.
• Took responsibility of maintaining the SQL Server instances to ensure software is properly installed, security patches were applied and upgrades were done.
• Safeguarding data by instilling backup, managing user access and securing databases.
• Approved and ran scripts for Quality Assurance and Production releases.
• Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.