Sweta

• 10+ years of experience in gathering business requirements, analysis, object - oriented design, data modeling, systems development, implementation & administration. • Coordinated with Project Manager, Team Lead, Quality Analyst, and Subject Mater Experts (SME) and worked closely with client/vendors to understand the business requirement. • Responsible for developing and maintaining custom integrations between various on campus databases and third party vendors. Familiarity with ETL, SQL, scripting languages, job scheduling tools, reporting and logging. • Worked as Data Analyst on data warehouse system using reporting tools SSRS in an organization. • Worked on SQL Server and Oracle database objects and created joins, views, stored procedures, user defined functions and packages. • Created tools, applications, and automations to replace, improve, or add new value to job duties and tasks inside IT department and sometimes outside as well. • Extensively used Global Scape server, UNIX, Sterling EFX solution, FileZilla, Puty, FTP Schedulers and PGP for production support. • Provided weekly metrics data to technical team for the total SQL and informatica jobs run in a week for further analysis and reports to Project Manager and business owners. • Created overall automated Workflow of the overall project including for FTP & Extracts. • Responsible for developing and maintaining custom integrations between various on campus databases and third party vendors. Familiarity with ETL, SQL, scripting languages, job scheduling tools, reporting and logging. • Scheduling and Monitoring ETL and Tidal processes. • Co-managed Banner and Degree Works Document Management Suite including support for existing solutions and developing new solutions. • Strong analytical, problem solving and troubleshooting skills. • Able to work collaboratively, understands business needs and system architecture and focused to achieve corporate goals. • Excellent communication and inter-personal skills with strong troubleshooting, and problem solving ability, good team player, self-motivated and worked in multicultural environment. • Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for 24x7 availability of the database. • Responsible for well-functioning of the database by checking and applying Patch sets and Interim patches. • Upgraded oracle databases from 11g to 12c to 18c. • Experience in using OEM/Grid Control along with beacon setup on both database and application servers. • Planning and scheduling the Physical (Cold/Hot) backups, Logical backups and RMAN incremental backups. • Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager) • Expertise in Oracle OEM 12c implementation and operations in an enterprise scale. • OEM 12c/13c installation, upgradation and patching. • Worked as a team member to provide 24x7 coverage on call for business system and database support. • Conducted and atained various SWAT calls for numerous issues with internal departments and external vendors. • Experience with many Installations, Configurations, Up-gradations, Platform Migration, Administration and Patching of Oracle Applications and Oracle databases. • Cloning of Databases from Production to Development and Test. • Developed, reviewed and executed Test Cases and Test Scenarios. • Design and implementation of Backup & Recovery strategies. • Writing UNIX shell scripts for database management and various cron jobs. • Hands on UNIX and Linux system administration. • Atained and participated in various Information and Technology Programs representing Confidential. • Worked on to reissue of expired SSL certificates and installation of new SSL certificates for application servers.