Tanvy P.

DATABASE DEVELOPER

343 dollar
Freelancer
11 ans
Newark, UNITED STATES

Mon expérience

Voir plus

Ungerer & CompanyJune 2018 - Présent

* Design E/R Models & solve critical database issues; space management

* Apply PSU patches & design data migration plans

* Implement Oracle FGA using custom made PL/SQL procedures, custom made functions to setup Oracle's VPD & database maintenance tasks

* Test & Implement Oracle's RMAN backup & recovery policies

* Performance tuning & designing database refresh procedures for test environments
(Environment- 2 node RAC Oracle 11gR2, SQL Server 2012, MySQL)
Voir plus

FiservApril 2019 - Présent

* Developing stored procedures/functions/triggers

* Setting up multi-tenant schema and data population

* Performance tuning/designing partitioned tables

* Extensively working on partitioned tables, exchange partitions and developing related stored procedures

* Preparing scripts for migration of data from development to staging to Production release & version control

* Designing E/R Models for better understanding of schema
Voir plus

OnPoint Intl. LLCJanuary 2018 - June 2018

* Performed initial installation/creation of 11g Oracle databases

* Implemented conceptual database designs and logical models

* Planned and implemented backup and recovery strategies

* Performed capacity planning for database growth, user management & space management
(Environment- standalone 11g production & development databases, initial setup)
Voir plus

CitiustechJune 2012 - July 2017

* Worked on numerous US Healthcare domain projects for clients GE (General Electric), Hyland software, Ability Networks)

* Working with clients, information architects, system admin and developers to define information flow helping to transform business requirements into environment specific databases

* Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)

* Configuring TAF & database services, testing failover operations for RAC

* Performed ongoing patches both rolling & downtime patches

* Performed Database Refresh from Production to QA, Staging and Development databases using shell script.

* Implementing BDD code and packages in the staging environment

* Configuring RMAN backup & testing recovery including flashback recovery

* Maintaining Recovery catalog database

* Creating RMAN auxiliary instance for developers testing environment

* Creating & Managing application users using Authstore application, post database refresh
(Environment- Max db. size 17 TB, OS- RHEL 5.x, Sun Solaris 5.10, Production (3 node RAC), Staging & Testing db.)
Voir plus

Magna InfotechDecember 2011 - June 2012

* Monitoring and supporting production, development, staging and test environments (exclusive RAC db.)

* Developing and maintaining operational standards/procedures for Oracle

* Optimizing database uptime/availability and performing database audits

* Creating physical standby for failover and monitoring log sync operations

* Managing user accounts

* Performance tuning sql and instance
(Environment- Max db. size 5 TB, 2 node RAC setup, standalone databases & physical standby)
Voir plus

In-Solutions GlobalMarch 2011 - December 2011

Oracle Standalone Db. Installation, Design & Maintenance for new project at client side BOBCARDS.
 Implementing Physical Standby Db. on Production environment & Performing DR Drill activity
Database Purge from Production to the Legacy database
Monitoring databases for redo log gaps, database users & quota management, creating database objects & index management, DB Links, import & export of data using Datapump
Creating, Scheduling & Monitoring database backups using RMAN & OEM
Generating Explain plan, Statspack report & troubleshooting database performance issues
(Environment- Max db. Size 2 TB , Oracle 9i & 10g R2, RHEL 4x; Production & Test db. Standalone with physical standby)

Mes compétences

Troubleshooting, TOAD, System administration, Sun Solaris, SSRS, SSIS, SQL Server Reporting Services, SQL Server Profiler, SQL Server Integration Services, SQL, Solaris, Shell Scripting, RHEL, Oracle PL/SQL, Oracle Developer, Oracle DBA, Oracle 9i, Oracle 12c, Oracle 10g, Oracle, MySQL, Microsoft SQL Server, Jira, ETL, Database Administration, Data Migration