Description
SUMMARY: * 11+ years of professional experience as Database architect, Administrator/Developer related to Financial, Mortgage, Health care and Manufacturing databases on SQL Server 2008 R2 / 2005 / 2000 / 7.0, Greenplum 3.3.4/4.1, Oracle 10g, PostgreSQL 9.0/9.1 * Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases. * Having good expertise in data modeling a metadata services. * Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full-text indexing, and Database Application Development using varied development tools. * Extensively worked on ETL design and development. * Expert in dimension modeling OLAP structures. * Performance Tuning & Application Design. * Hot and Cold Backups, Disaster Recovery Planning, Security Management * Expert in writing PSQL/T-SQL/PL-SQL Functions * Expert in handling Memory configurations for database servers. * Implemented Polymorphic data storage, Multi-storage/SSD support in Greenplum databases * Worked on implementing Multi level Data partitioning with dynamic partition elimination in Greenplum. * Worked on Out-of-the-Box Support for Big Data Analytics. * Worked on High Performance gNet for Hadoop. * Data modeling Experience like Physical data modeling and logical by using ERWIN. * Worked on Replication and Log shipping for SQL Server High Availability * Extensively worked on Active-Active and Active-Passive Clustering * Having hands on experience in Database Mirroring. * Expert in parallel data loading services gpdist, gpload. * Having Experience working on Data center servers and handling multi terabyte databases. * Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support. * Proficiency and expertise in Backup/Recovery, Disaster recovery planning and Security Management. * Troubleshoot performance problems, fine-tuning of databases and index Analysis. * Monitoring tools and Application support. * Experience in Oracle Database 9i/10g Administration. * Created PL/SQL packages, procedures and functions. * Having good experience in configuring and troubleshooting IIS and XML. * 24 X 7 Production Database on Call Support