We provide IT Staff Augmentation Services!

Sql Developer Resume

Framingham, MA

SUMMARY:

  • To obtain a challenging position in a high quality environment where my skills will add value to the organizational operations and I would put forth the best of my knowledge towards the growth of the organization.
  • Seek challenging assignments and responsibilities, with an opportunity for my growth and career advancement.
  • 7+ years of experience in databases predominantly in the field of PostgreSQL and MySQL Database administration with extensive experience in handling critical Reporting Applications.
  • A comprehensive working experience on operating systems like Linux, IBM AIX, Sun Solaris, and Windows.

STRENGTHS:

  • Leadership Skills.
  • Self - motivated.
  • Positive attitude and enthusiastic in teamwork.
  • Ability to work individually and in a team.

TECHNICAL SKILLS:

Databases: Postgre SQL, MySQL, Oracle

Operating System: Linux (OEL), Windows XP/7/8.

Languages: C, Java, Hibernate, STRUTS, springs, Java Script, JSP

Web Technologies: HTML.

IDE: Microsoft Visual Studio.NET 2008

Frameworks: .NET FrameWorks3.5

Programming Language: C#, .net

EXPERIENCE SUMMARY:

Confidential, Framingham, MA

SQL Developer

Responsibilities:

  • Managing 25 PostgreSQL and 5 MySQL Production Databases and their associated Non - Production Databases.
  • Installation and Configuration of PostgreSQL and MySQL Software and Creating Databases.
  • Provided production support to critical applications like Confidential Exchange, Service Now (Incident Management) Databases, Sales Databases, Financial Transactional Databases, and Customer Hub Databases.
  • Written over 70 Shell Scripts for Health Check automation and proactive maintenance of the Infrastructure including Infrastructure (Server/DB/Storage/Network) availability and bottlenecks such as Blocking/Locking, Fragmentation, Invalid Objects and Unusable Indexes etc.
  • Monitoring growth and managing space and estimation and Forecasting.
  • Setup and maintenance of disaster recovery/failover solutions and Building the Standby Environments for all the Databases and Monitoring the Synchronization of Standby database with Primary.
  • Handled Disasters including failover and loss of databases and storage for PostgreSQL Databases.
  • Performed PostgreSQL Database Migrations across different hardware and between different systems (OS Versions and RDBMs).
  • Established and Maintain Healthy Backup & Recovery Strategies and Procedures.
  • Server tuning by optimizing the memory utilization and monitoring the I/O bottle-necks and IO waits.
  • Handled Space Reclaim, Performance Improvement and De-fragmentation of Database Objects using VACUUM FULL and several other options.
  • Enabled Logging of Slow Queries and improved performance through several maintenance tasks on PostgreSQL and MySQL Database Tables using OPTIMIZE and Table Rebuilds.
  • Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts.
  • Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL and MySQL Databases as requested by the Application Teams based on criticality of the Applications.
  • Monitor Database Performance, CPU Utilization and Memory Resource Utilization.
  • Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.
  • Monitoring Space Utilization and Tablespace Usage and Table Fragmentation.
  • Managed Backups/Restore of PostgreSQL Databases using pg dump/pg restore and pg basebackup.
  • Managed PITR (Point-In-Time-Recovery) during Disasters for PostgreSQL Clusters.

Confidential, Rockville, MD

SQL Developer

Responsibilities:

  • Creating and designing the Databases as per the requirements and specifics tailored to the project’s needs.
  • Recommend changes to increase efficiency, minimize operating expense or improve accuracy and timeliness of application systems.
  • Modified most of the Queries and replaced them with Perfectly Tuned SQL’s which generates Accurate Data.
  • Re-written most of Complex SQL’s to ensure best possible Execution Time for the Queries.
  • Most of the Reports being generated were run through my Automated Queries for which I was recognized as the Best Analyst of the Quarter.
  • Written multiple Shell Scripts that automated Backups/Recovery and Space Reclaim from all the Database Servers.
  • Perform maintenance activities in strict downtime.
  • Refreshing development / test database from production using pg dump and pg restore.
  • Performance monitoring/tuning, space monitoring, tuning of SQL statements for optimum performance.
  • Coordinating with application team and advising the development team accordingly to solve technical issues.
  • Automation of Database jobs as required by the applications.
  • Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.
  • Monitoring Space Utilization and Tablespace Usage and Table Fragmentation.

Confidential, Seattle, WA

SQL Developer

Responsibilities:

  • Managed 20 PostgreSQL Production Databases related to Voice-Call Analytics.
  • Installation of Postgres Binaries and created several Clusters on different Ports and Servers and Created several Databases.
  • Written Shell Scripts that automatically takes Full Database and Archive Backups and Archive Deletion Confidential regular intervals for all PostgreSQL Databases.
  • Involved into L4 Support to resolve all the Performance Issues which cannot be resolved by L1, L2&L3.
  • Worked extensively on several performance issues that act as a bottleneck for Application Teams.
  • Managed Backups/Restore of PostgreSQL Databases using pg dump/pg restore and pg basebackup.
  • Managed PITR (Point-In-Time-Recovery) during Disasters for PostgreSQL Clusters.
  • Regular Proactive Health Checks for all the PostgreSQL and MySQL Databases through my automated shell scripts.
  • Managing/Building Standby (Slave/Replication) Servers for all the PostgreSQL Databases as requested by the Application Teams based on criticality of the Applications.
  • Monitor Database Performance, CPU Utilization and Memory Resource Utilization.
  • Monitor the Sessions and the Database Activity and identify Sessions causing Contention and work on the Root Cause Analysis.
  • Monitoring Space Utilization and Tablespace Usage and Table Fragmentation.
  • Handling Database Migrations and Refresh Database or Schemas and Tables as requested by the Application Team.
  • Migration of Data from Reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures.
  • Deploy the Database Objects requested by the Application Team.
  • Collect the Dumps generated by several reports from PostgreSQL Databases and importing to Archival Databases for Archival and Purging.
  • Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the cronjob periodically in regular intervals.
  • Written Complex Shell Scripts that automates the Import of Reports to PostgreSQL and MySQL Databases.
  • Write Queries to avoid Duplicate updates and maintain Consistency.
  • Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
  • Write Complex SQL’s to generate the Data needed and send it to the Team.
  • Update the Statistics of All the Database Objects to avoid any Performance Issues.
  • Monitoring Daily Health Checks of all my PostgreSQL Databases through my automated Scripts.
  • Managing Connection Issues and User Creations, Roles and Privileges of PostgreSQL Databases.
  • Handled Database Switchover/Failover for PostgreSQL Databases.

Hire Now