Banner Image

All Services

Programming & Development

Sr. DBA (Oracle, SQLServer, Netezza)

$50/hr Starting at $25

• A certified professional DBA (Oracle, SQLServer, MySql, Netezza, MangoDB, Postgress, Cloud AWS/Azure) with over 12+ years of experience in Production Support, Build, Migration, up-gradation of databases technologies. • Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment. • Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard. • Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database. • Cross platform migration/upgrade of databases from 10g to 11g/12c using transportable tablespaces from Linux to HP-UX. • Netezza support, administration, coordinate multiple Netezza projects and Netezza administration ( backup , stats collection, grooming and performance tunring). • Worked with client representatives and internal / external consultants. Assist on other application projects as needed on Netezza. • Upgrade Netezza to latest version. • Experience in Oracle Azure/DBA/AWS in daily support of corporate management systems including database management and administration, analysis, design, software testing and architecture in client/server and web-based environments with reference to Azure/AWS, spanning several industries: financial services health care, and high tech • Experience on AWS cloud services like EC2, S3, RDS, ELB, EBS, VPC, Route53, Auto scaling groups, Cloud watch, Cloud Front, IAM for installing configuring and • Experience in install and support OEM Grid control 10G/11G/12c. • Expert in Backup & Recovery using Data Pump, Hot, Cold, Logical and RMAN • Developed Shell Scripts to Automate RMAN Backups, Hot/Cold backups, Imp/Exp, Datapump and Schema Refresh, and Production to Dev/Stage Sync up etc. • Involved in Installation and configuration of MS SQL Server 2005, 2008 R2 and 2012 on Windows 2003/2008 environment. • Experience in migrating from SQL server 2000 to SQL Server 2005 and SQL server 2008/2008R2. • Administrating high availability solutions like clustering, Logshipping, mirroring and Replication. • Expert in implementation of SQLServer 2012 AlwaysOn. • Experience in implementation High availability using Golden Gate Replication and Bi-directional replication using golden gate • Leading/architecting the migration of large scale database environments into VBlock virtual environment. • Install, configure, upgrade and support Mysql environment. • Hiring and Setting up the DBA team in India and US and train them. • Define, install and configuration of MS SQL Server 2005, 2008 R2, 2012 and 2014 on Windows 2003/2008/2012 environment. • Expert in implementation of SQLServer 2012 AlwaysOn. • xcellent SQL and PL/SQL programming and debugging skills – Triggers, Stored Procedures etc • Experience in install, upgrade and support Netezza 6.x/7.x. • Experience in large size database support (up to 9.6+ terabytes) • Skilled in writing, modify

About

$50/hr Ongoing

Download Resume

• A certified professional DBA (Oracle, SQLServer, MySql, Netezza, MangoDB, Postgress, Cloud AWS/Azure) with over 12+ years of experience in Production Support, Build, Migration, up-gradation of databases technologies. • Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 11g RAC environment. • Expert in Installation, Configuration and Maintenance of Oracle Standby/Data Guard. • Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database. • Cross platform migration/upgrade of databases from 10g to 11g/12c using transportable tablespaces from Linux to HP-UX. • Netezza support, administration, coordinate multiple Netezza projects and Netezza administration ( backup , stats collection, grooming and performance tunring). • Worked with client representatives and internal / external consultants. Assist on other application projects as needed on Netezza. • Upgrade Netezza to latest version. • Experience in Oracle Azure/DBA/AWS in daily support of corporate management systems including database management and administration, analysis, design, software testing and architecture in client/server and web-based environments with reference to Azure/AWS, spanning several industries: financial services health care, and high tech • Experience on AWS cloud services like EC2, S3, RDS, ELB, EBS, VPC, Route53, Auto scaling groups, Cloud watch, Cloud Front, IAM for installing configuring and • Experience in install and support OEM Grid control 10G/11G/12c. • Expert in Backup & Recovery using Data Pump, Hot, Cold, Logical and RMAN • Developed Shell Scripts to Automate RMAN Backups, Hot/Cold backups, Imp/Exp, Datapump and Schema Refresh, and Production to Dev/Stage Sync up etc. • Involved in Installation and configuration of MS SQL Server 2005, 2008 R2 and 2012 on Windows 2003/2008 environment. • Experience in migrating from SQL server 2000 to SQL Server 2005 and SQL server 2008/2008R2. • Administrating high availability solutions like clustering, Logshipping, mirroring and Replication. • Expert in implementation of SQLServer 2012 AlwaysOn. • Experience in implementation High availability using Golden Gate Replication and Bi-directional replication using golden gate • Leading/architecting the migration of large scale database environments into VBlock virtual environment. • Install, configure, upgrade and support Mysql environment. • Hiring and Setting up the DBA team in India and US and train them. • Define, install and configuration of MS SQL Server 2005, 2008 R2, 2012 and 2014 on Windows 2003/2008/2012 environment. • Expert in implementation of SQLServer 2012 AlwaysOn. • xcellent SQL and PL/SQL programming and debugging skills – Triggers, Stored Procedures etc • Experience in install, upgrade and support Netezza 6.x/7.x. • Experience in large size database support (up to 9.6+ terabytes) • Skilled in writing, modify

Skills & Expertise

AWSAzureBusiness ConsultingData BackupLinuxManagementMicrosoftMySQLNetezzaOracleProgrammingSoftware DevelopmentSQL

0 Reviews

This Freelancer has not received any feedback.