SUMMARY

• 8 years of experience in Designing, development as PostgreSQL database architecture.
• Migrated some Oracle databases to PostgreSQL databases.
• Broad range of administrative and development functions while supporting Oracle and PostgreSQL implementations.
• Installed, configured, and maintained databases and software (PostgreSQL & Oracle). Developed functions, procedures and triggers using PL/SQL and PL/PGSQL.
• Discovered poorly performing queries and tuned them.
• Backup and Recovery Management.
• Configured master/slave replication using PostgreSQL streaming replication. Developed shell script to rebuild the failed master after a failover.
• Use best practices to optimize PostgreSQL cluster.
• Regular Proactive Health Checks for all thePOSTGRESQLand MySQL Databases through my automated shell scripts.
• Very good Programming skills in creating SQL objects like Tables, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Migration of Data from Reports generated by various vendors intoPostgreSQLDatabases using PostgreSQLExport/Import Procedures.
• Directly involved in the tuning/optimization, migration, partitioning, monitoring upgrades and other general database admin duties.
• Developed backup strategy for productionPSQLdatabase that stored daily backups.
• Developed PHP,PSQL/SQL and shell scripts to automate the Linux based database through apache web server.
• Extensively wrotePSQLQueries and Stored Procedures for implementing complex business logic and develop Database Triggers to enforce Data integrity.
• Managed over 2500 databases and the largest database was around 5 TB.
• Written Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables.
• Experienced in Configuring, Implementing and Maintaining Database Mirroring.
• Highly experienced in Configuration, Implementation, Maintenance and monitoring of Log Shipping.
• Building ETL processes using scripting languages like Scala, Python.
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning, Data partitioning and Data Normalization.
• Expert in capacity planning, performance tuning, and disaster recovery and troubleshot performance issues.
• Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Hands on configuring Temp DB with considerable Memory and Raid Levels for better performance.
• Acquaintance in supportingVery Large databases(VLDB) more than3TBand troubleshooting the problems
• Was part of team for configuring storage.
• Used Microsoft team foundation Suite (TFS) to check in and check out the TSQL code, SSIS packages and SSRS reports.
• Experience in the migration of DTS to SSIS 2005/2008.
• Handled numerous change management requests on production servers
• Configuring and maintainingReport ManagerandReport Server.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Created Linked Servers between SQL Servers and also to Oracle Databases.
• Experience working in a team - oriented, collaborative environment. Demonstrated ability to successfully manage, lead, and inspire a team of technical professionals.

TECHNICAL SKILLS

Databases: PostgreSQL, T-SQL, MS SQL Server 2014, MS SQL Server 2012, 2008R2, 2008, 2005, 2000, SQL*Plus, SQL*Loader.

Programming: Visual Basic 6, Visual Basic 5, C, C##, .Net & SQL, PSQL.

DBA: PostgreSQL Administration, MS SQL Server 2014, 2012, 2008R2, 2008, 2005, 2000 databases

Operating System: Windows 2008/2005/2003/2000, Unix/Linux, Advanced Server, NT.

Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML

Tools: Perf Mon, Backup Utility, SQL Lite Speed, Cassandra, Visio, ERWIN, RML Utility, SQL Safe, SQLDM, SQLCM, MS Dynamics, Visual Studio 2012

Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Postgre SQL Developer

Responsibilities:

• Discussing and solving the issues on current database design, modeling.
• Gathering requirements as BSA (Business system analyst).
• Building PostgreSQL on top of Green plum.
• Writing top scripts as per end user.
• Building ETL process and final output tables.
• Pulling data from SIBEL, load data into mirror layer.
• Writing Functions, Produce Tables to consume reporting needs.
• Using MVCC for data integrity to avoid dirty needs.
• As per end user requirement, created online reports and collecting data and creating Visualization reports.
• Checking Health care products, its reliability and pricing.
• Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Implementing backup and recovery (Logical and Online). creating PostgreSQL objects like Tables, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.
• Performing schema management; database sizing, maintaining privileges.
• Data migration while upgrading database versions.
• Configuring Point in time recovery (PITR) to minimize downtime from recovery situations.
• Installing and monitoring PostgreSQL database using the standard monitoring tools.
• Daily log analysis and query tuning.
• Maintaining custom vacuum strategies at table and DB level.
• Monitoring the DB growth for every month and if incase of DWH DB planning to implement table partitioning for better performance.
• Monitoring the bloat repot on every table and performing maintenance with minimal downtime.
• Performing the minor and major level upgrades using minimal down time.
• There was an initial onsite engagement for an Architectural Health Check onPostgreSQLServer.
• Improvements in the schema design to obtain better performance from thedatabase.

Confidential, SLC, UT

Postgre SQL Developer /DBA

Responsibilities:

• ManagingPostgreSQLproduction databases. Applying PostgreSQL patches and schema changes.
• Analyzing and implementing new technologies with PostgreSQL server.
• Working with QA and R&D teams to ensure stable release patches. Helping with the MongoDB patch deployments.
• Upgrading PostgreSQL and replicationmodules and keeping them up to date.
• Key responsibilities includedsetting upPostgreSQLdatabase with replication and implementing in house backupsolutions.
• Leading the project for migrating Oracle database toPostgreSQLserver. Which was completed successfully.
• Responsible for setting backups and maintainingGreen plum Servers.
• Analyzing customer requirements and recommending/implementing RFC's (request for change).
• Maintaining the application responsible for extraction of data from SQL Server and importing it into Green plum Servers.
• InitialCustomer engagement, understanding the project requirements, recommending the best architecture according to customer business needs.
• Handling pre-sales queries for Asia Market. Technical expert for prospect customer engagements.
• PostgreSQLimplementation, customization to run the database in line with the Customerexpectations.
• Implementing High availability solutions usingPostgreSQL Migrating from different databases toPostgreSQL.
• Performing Architectural Health Checks for building short and long term recommendations.

Confidential, Minneapolis

SQL Server DBA\Developer

Responsibilities:

• Deployed and Administrated SQL Enterprise servers on production environment.
• Implemented database security by maintaining SOX compliance standards.
• Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements. Experience in applying Service Packs at database and OS Level.
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM.
• Developed, implemented and monitored a large-scale and time-sensitive production loading processes
• Develop and implement replication, archiving and backup and recovery strategies
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Managed Security using SQL Logins, Roles and Authentication Modes for various categories of users.
• Expert in Using Performance dashboard, Mirroring, database snapshot.
• Evaluated data storage considerations to store databases and transaction logs.
• Export or Import data from other data sources like flat files using Import/Export through DTS.
• Expertise in trouble shooting of Client connections, viewing error log and applications.
• Implemented Snapshot replication.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Experience in Migration of Data from PostgreSQL to MSSQL using PG Dump Utilization tool and BCP.
• Used Log shipping for synchronization of database.
• Involved in generating various reports using the SQL Server Reporting Services.
• Documented Trouble-shooting guide for various issues.
• Exposure in Data modeling tools such as Erwin, Microsoft Visio and Red Gate.

Confidential

SQL Server Developer

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Migrated DTS packages into SSIS packages.
• Handled up to 2 TB Size databases with clustered and standalone environment
• Configured Transactional replication on migrated server.
• Wrote the packages using SSIS in SQL2005.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
• Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
• Used DTS packages to move logins and jobs from one server to another server.
• Used log shipping for synchronization of database.
• Good experience in data modeling and metadata services.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the Performance of the Stored Procedures.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Converted logical Database Design into Physical schema using the balanced normalization in 2ndand 3rdNormal form for highest performance.
• WroteStored Proceduresto implement business logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Transfer data from flat files, Excel spreadsheets to and from SQL Server usingDTS, BCP and Bulk Insert.
• Managed test data and their updates between development and production databases.
• Handle development and production support, document reviews, test plans, integration of the system.
• Document all process and Data Flow involved in the database for future reference.