Swati Lotlikar

Senior Oracle Database Administrator

952-***-****

ac8eer@r.postjobfree.com

Summary:-

- Make sure Oracle database systems operate efficiently and securely.

- Proficient in designing and implementing complete life cycle client servers and database applications with various development tools and languages.

- In-depth knowledge of security and backup procedures to ensure database integrity.

- Excellent communication, presentation, analytical and problem solving skill. Co-ordinate well with all levels of business.

-Experienced architecting, capacity planning, designing, implementing, managing and supporting OLTP or Warehouse Database Management Systems.

-High Availability, MAA and DR: Real Application Clusters & Active Data Guard

-Database Architecture Design and PL/SQL : Database Installation, Configuration and Patching including RAC and OEM Database Performance Tuning.

-Knowledge of other Database brands : SQL Server 2005/2008, DB2(9.x), Teradata 13.0

-Database Security, Encryption, Compression and Data Masking/Redaction, Backup and Recovery, DataPump and SQL*Loader, Oracle Enterprise Manager Grid Control & Cloud Control.

-Expertise in automating database provisioning DBaaS Oracle 11g/12c Non-CDB-PDB/Multi-tenant architecture, using shell scripts, and or OEM12c, with charge-back cloud API orchestration.

Proficient in security automation related to business data, entitlement reporting, idam, break the glass.

Certification

-Oracle9i/11g/12c Certified Professional.

-DB2 LUW Associates certification.

Specialties

• Databases- Oracle12c/11g/10g/9i/8i, SQL Server 2005/2008, DB2(9.x), Teradata 13.0 [Proficient]

• Operating Systems- UNIX, Linux, Windows NT/XP/Vista.

• Scripting- PL/SQL, Shell, EMCLI.

• Tools- RMAN, DataGuard, Data Pump,Oracle Enterprise Manager Cloud Console, Oracle Diagnostics Pack, Oracle Performance Pack, STATSPACK, TKProf.

Work Experience

Senior DBA

Be The Match operated by National Marrow Donor

Febrary 2015 – Present

-Worked with Wells Fargo for inbound-outbound file transmissions with NMDP Production E-Business Suite modules.

-Build, research, plan and implement upgrade to 11.2.0.4 (DST package) for all Non-EBS Oracle databases in ecosystem. During the upgrade process there was standardize solution of one unix ID/group implemented and consistent naming conventions for all oracle internal components.

-Implementation of DICOM images, using 11gR2 Securefiles and TDE tablespaces AES-256 encryption on specific assets to follow specific privacy and security guidelines.

-Support DBA on Amazon Web Services (RDS) used for burst data management model, oracle 12c SE 2 edition, with m4 databases.

-Build a one-stop place for complete, integrated, and business-driven enterprise Cloud Management solutions, OEM12c, a monitoring and management software for all aspects of Oracle database, Fusion Middleware, and associated applications. Administrative groups, BI Publisher, Incident rules.

-OEM13cR3 build all feature for OEM12cR5 and additional enhanced features like system broadcast support, corrective action enhancements, build chef job, cookbook support, automated workload repository, policy compliance scores and evaluation, fleet maintenance, research for sync support for data guard, exalytic patching (ASR) and Snap cloning using test master snapshot, lifecycle management-inventory usages.

-Automation of Oracle 12cR1 database rapid provisioning by the way of self-service infrastructure, providing agility in application deployment, reducing overall time in deploying production applications, development platforms, or creating test bed configurations. DBaaS- Database as a Service and Schema as a Service.

-Build, research, plan upgrade to 12.0.1.2 for all Non-EBS Oracle databases in ecosystem.

-Research & Plan implementation of dNFS and automated Software library patching solution using OEM12c.

-Partner with project teams and interact to find solutions for projects and operational issues for existing and proposed databases that will support leveraged technologies like flyway, springbot, githu and many more new age technologies.

Design storage strategies around backup and recovery for complex database environments, physical structures and specialized database applications/systems,

Database Administrator

MNDot: FTE

Septemeber 2014 – December 2014

-Work on DataModelling and primary DBA for contract agreements project.

-Work on resolving CPU and latency bottlenecks for Vsphere for Windows NT6.1 on Oracle 11g.

Database Administrator

Delta Airlines, Consultant

January 2014 – September 2014

- Support for 3 node, 2 node and standalone oracle databases.

- Primary support for all databases on MLT / delta vacations line of business.

- Work with SA on Cloning, disk mirroring and asm disks configuration on monthly basis from production to development and testing.

- Work with apps, middleware and os team for change request deployment on production databases .

- Reorg tablespaces and datafiles reclaimed more than 200gb/database.

Database administrator

Donaldson: Consultant

July 2013- Jamuray 2014

-Create jython scripts using [EMCI: enterprise manager command line interface] for automating tasks of oracle enterprise console used for cloud computing.

-Co-ordinate with the architects and SA on IT Infrastructure Enhancements project.

-Work with in-house DBA to give DG configuration and best practice consultation reports to the manager.

-Collaborate on DR plan using RMAN, shell scripts and archival policies on using DG and physical standby +FRA.

Database Administrator IS/TA 5: Consultant

City of Saint Paul: Consultant

December 2012 – July 2013

-Support Oracle developers, performed database tuning, created database reorganization procedures, database alert scripts, monitoring scripts and backup procedures.

-Duties include all aspects of Oracle database administration including performance & tuning, Oracle installation and Oracle upgrade, database maintenance, database migration and database recovery.

-Assist with database administration for a city-wide distributed system like police, 911 emergency, parks & recreation databases. Gathered statistics and wrote UNIX scripts to compress, backup and maintain the remote databases. Developed a performance & tuning system using tools and process.

-Implement APEX schema and FLOW_FILES schema for Java Application Support. Diagnose the Middleware TOMCAT,Weblogic support using database connection pools.

-Work with commercial-of-the-shelf application vendors and project managers to configure supporting databases. Diagnose and resolve code/data/capacity issues in collabaration with SA and vendors using SR process.

-Create work plans and submit proposals to Senior Management for resources that would bring more sustainability to the current environment. Make test plans and feasibility reports for the DBA group to migrate databases from Oracle 10g to 11g.

Business Analyst

United Health Care: Consultant

May 2012 – December 2012

- Establishing and maintain data management policy. Create secure flow data flow plans for collection of sensitive enterprise data that will be used across all sectors of corporate environment.

- Diagnose data warehouse content, define data definitions.

- Implement data consistency and integrity.

- Implement capacity planning, data warehousing and data modeling skills.

- Works with data governance team to focus on managing the quality, consistency, usability, security, and availability of information.

- Establish data profile, build physical and logical database.

- Create backup plans and work on building and tune queries to generate reports.

Database Security Analyst

Wells Fargo Bank: Consultant

October 2010- December 2011

- Administered security policies on 10000+ production databases on multiple platforms.

- Implemented user certification as per company standards using SOX applications.

- Install, upgrade, and configure Oracle Software and check SQL*Net listener availability.

- Created log generating scripts on multiple instances for administration of 5000+ users.

- Trained junior analyst in security compliance policies and process for auditing.

- User certifications were administered on Oracle9i, 10g, 11g, SQL Server, DB2, Teradata.

- Responsible for Oracle and MySQl logical and physical database design, implementation and maintenance.

- Created new databases, involving importing and exporting; installed and configured database software for application development environment.

- Managed database SQL tuning, application tuning, maintaining documentation and manuals, capacity planning and security.

Technology Trainer

Lutheran Social Services, Minneapolis

June 2010 – October 2010

- Conducted technical programs, designed the curriculum and coordinated collaborative field and research projects with local industries.

- Trained employees and clients with Microsoft suites application to increase productivity.

- Increased substantially the quality of training program and quantity of clients for the program.

- Created database for logging information of curriculum, clients and students.

- Generated reports that facilitate the overall working of class schedules and curriculums.

Database Architect/ Administrator

Voltas, Mumbai

March 2004 – November 2004

- Installed, created, Oracle 9i and MS-Access databases for two departments from planning and testing through production.

- Implemented backup and recovery procedures in Linux environment and published IT department manuals on intranet.

- Handled database remodeling, interface development and report generating queries during migration from MS-Access to Oracle9i.

- Enhanced the Oracle9i database with security policies and increased the stability of the database with job scheduling reports to the managers.

- Involved in all phases of database development from needs assessment to QA, design and support.

Database Administrator

Bench Mark Solutions, Mumbai

January 2001 – February 2004

- Responsible for SQL Server and Oracle 8i/9i installation patching on Windows NT/Linux platforms at Lilavati Hospital.

- Created new databases and user certification on Oracle 9i database systems on Linux platforms.

- Handled job scheduling and monitoring scripts, setup backups and exports.

- Implemented database refresh using table exports, index rebuilding and database defragmentation, effectively improved space management and improved performance.

- Provide technical support by WO in database management and DRI plans. Installing and supporting physical standby database.

- Recognize, recommend and implement all new database technologies and oracle license agreements.

- Coordinated efforts with client to deploy enterprise-wide financial and reporting systems, performing design, development and implementation support and documentation completing project within 3.5-year time frame.

Technical Support Analyst

Aptech Limited

June 2000 – December 2000

- Worked on drafting examination paper on various technologies and concepts like MS-Office, XML, Java, Oracle, SDLC.

- Evaluate peer work on lab questions and make recommendations.

- The examination papers were drafted as per the textbook used by specific level of students.

- Co-ordinate with supervisor on course work and build questions banks on basis of difficulty level.

Education

Bachelors of Commerce, Mumbai India.

Associate Business Management, Minneapolis MN.

Bachelors Business Administration, Saint Paul MN.

Contact this candidate