We provide IT Staff Augmentation Services!

Sql Server Developer Resume Profile

SUMMARY:

  • 10 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, Managing server and clients, T-SQL/PL/SQL/SQL Lexicon, Stored Procedures, Functions and Cursors and Triggers etc.
  • Handling Memory configurations for database servers.
  • Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
  • Expertise in writing complex MDX, DMX and XMLA queries.
  • Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
  • 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 data loading services like SSIS, DTS, BCP Bulk Insert and gpdist,gpload and copy commands.
  • Having Experience working on Data center servers and handling >1.4 TB databases.
  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
  • Proficiency and expertise in SQL Server Replication, 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 integrating ERP systems with MS Sql server and also can understand working code of ERP systems such as SAP-ABAP etc.
  • Having good experience in configuring and troubleshooting IIS and XML.
  • 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

  • Project Domain: Application Development, Systems Integration and Database Administration of MSSQL Server 2005/2000/7.0/6.5, PostgreSQL 9.0/9.1
  • Languages: Java, Visual Basic 6/5, ASP.NET, C, C , C , XML, HTML
  • Database: SQL Server 2005,2000/7.0/6.5, Greenplum 3.3.4/4.2, PostgreSQL 9.0/9.1, DB2 8x UDB, Access and Sybase
  • Tools: Active X, IIS, SSIS, DTS, MTS, litespeed, Spotlight.
  • ETL Tools: Informatica 7.1.2/6.1.X.
  • Business Intelligence: Crystal Reports XI/10/9, Business Objects XI/6.5.1.
  • Operating System: Windows 2003/2000 Advanced Server, UNIX,Linux, NT Windows 9x.
  • Other: Microsoft Office word, excel, power point, outlook , MS Visio, Visual Studio 2005, 2003.

PROFESSIONAL EXPERIENCE:

Confidential

Sr Greenplum/PostgreSQL Consultant

  • Database Administrator, Database Programming.
  • Closely worked with SME to understand requirements.
  • Reverse engineered data models to improve Green plum function queries.
  • Worked on changing distribution keys to avoid data skew and improve performance.
  • Worked on end to end application level performance tuning re designing data models ,choosing proper distribution keys re write greenplum function code.
  • Extensively worked on ELT performance tuning using multiple Gpfdist instances and available hardware
  • Worked on Greenplum features, benefits, and understanding architecture in terms of shared
  • nothing and the MPP design and how Greenplum supports redundancy and high availability
  • Install, initialize, validate, and configure Greenplum Databases.
  • Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues.
  • Implemented Greenplum's Advanced workload management for dynamic query prioritization.
  • Designed and implemented table partitioning for handling very large tables.
  • Load data into a Greenplum database instance using external tables, SQL copy and insert commands, and parallel load utilities.
  • Extensively used gpfdist and gpload utilities for data load and unload.
  • Extensively used data manipulation language and data query language to access, manage,and query data.
  • Perform system administrative tasks, managing and checking the state of the Greenplum databases and its distribution of data.
  • Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
  • Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.
  • Planned and implemented disaster recovery of greenplum databases using EMC data domain
  • Perform backup and restoration of Greenplum databases using gp crondump,gp backup,gp restore utilities on EMC Data Domain.
  • Improve query performance by following performance enhancement tips and database best practices.
  • Expert in writing complex SQL scripts.
  • Expert in writing shell scripts.

Confidential

LEAD Greenplum/Postgre SQL DBA/Developer

  • Database Administrator, Database Programming.
  • Played a key role in data modeling datawarehouse for reporting needs.
  • Install, initialize, validate, and configure Greenplum Databases
  • Manage database objects and workload management processes by defining and managing roles, privileges, and resource queues
  • Designed and implemented table partitioning for handling large tables
  • Load data into a Greenplum database instance using external tables, SQL copy and insert commands, and parallel load utilities.
  • Extensively used data manipulation language and data query language to access, manage,and query data.
  • Perform system administrative tasks, including managing and checking the
  • state of the Greenplum database and its data and checking the distribution of data.
  • Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
  • Worked on Improving query performance by keeping statistics up to date and tuning the database for sampling size and error conditions.
  • Perform backup and restoration of Greenplum databases
  • Distribute and store data in Greenplum using a distribution key and partitioning
  • Worked on optimizing indexes for better performance and maintainability
  • Improve query performance by following performance enhancement tips and database best practices.

Confidential

LEAD DBA/Developer

  • Worked closely with end-users to Define Requirements, Resolve Issues, Troubleshoot problems and Provide Solutions for various applications and day to day business needs.
  • Actively involved in Data Modeling a new star-schema based database from legacy flat tables to improve performance, redundancy and scalability.
  • Designed and Developed mortgage models, pricing models, tax reporting models.
  • Wrote complex stored procedures, triggers, functions and T-SQL.
  • Tuned stored procedures for performance improvement.
  • Daily administration and tuning of SQL Server 2005 and 2008 R2 servers
  • Designed, developed and implemented Databases from scratch.
  • Involved in logical and physical data modeling.
  • Suggested and configured High availability solutions like Database Mirroring, Clustering and log shipping.
  • Designed, Created and Implemented complex SSIS packages for data warehouse
  • Good knowledge in Mortgage data analysis and elements.
  • Planned and Configured Team Foundation Server TFS for maintaining source code and version control.
  • Created Release Process Documentation to establish a staged migration method from the Development to the Production environment.
  • Release deployment Lead responsible for mentoring other developers and ensuring best practice for coding and deployment were followed.
  • Responsible management of offshore DBA and developers.
  • Designed, Developed and Tested automation of Tax Reporting.
  • Worked on Oracle OBIEE for designing, building complex reports.
  • Responsible for performing a Proof of Concept using Microsoft Windows AZURE to demonstrate cloud technology to the client.
  • Have good experience with SSIS, SSRS
  • Extensive use of Red-Gate SQL Server and Developer Tools

Confidential

SQL Server DBA/Developer

  • Closely worked with business users in gathering requirements to provide key data for critical business decisions.
  • Developed logical design and physical design
  • Administered and maintained Production/Development servers with more than 2 TB of database size with complex structures.
  • Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
  • Worked with SQL server Profiler to generate traces to find long running stored procedures and queries to tune for peak performance
  • Integrated SQL server profiler traces with Performance monitor to have better graphical analysis to find system bottlenecks.
  • Expertise in Fine tuning complex queries
  • Expertise in setting up and troubleshooting Database mirroring.
  • Optimized working process.
  • Rebuilding the indexes at regular intervals for better performance
  • Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
  • Configured up to 32 GB of memory.
  • Was responsible to develop customize reports requested by clients.
  • Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema designs.
  • Generated reports by using Repots using SSRS.
  • Redesign/ Deploy reports using Report Services 2008.
  • Used Reporting Services SSRS to schedule reports to be generated on predetermined time.
  • Created report models for Report Builder and managed reports using Report Manager.
  • Created ad-hoc queries from SQL Server databases for custom reporting needs.
  • Created sub reports, cross tabs, charts, ad-hoc reports using SSRS.
  • Tuned servers to the peak for maximum performance by configuring memory and various server level parameters.
  • Involved in developing C , C code as a part of various transition projects.
  • Hands of experience in writing batch files.
  • Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server using SSIS.

Confidential

SQL server 2005 DBA/Developer

  • Worked on Client/Server tools like SQL Server Management studio 2005 , SQL Server Enterprise Manager 2000 and Query Analyzer to Administer SQL Server.
  • Worked closely with ERP SAP development team in integrating SQL Databases and troubleshooting issues as and when needed dynamically.
  • Handled up to 2 TB Size databases with clustered and replication environment
  • Wrote the packages using SSIS in SQL2005.
  • Configured more than 2 GB ram on 32 bit Environment.
  • Worked in Active passive cluster environment.
  • Used log shipping for synchronization of databases.
  • Prepared Documentation for the Disaster Recovery plan
  • Implemented new topics like CLR integration on Development Server.
  • Wrote and debugged Stored Procedures and DDL /DML Triggers , Functions as per client requirements
  • Extensively worked on Dynamic Management Views DMV's .
  • Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
  • Planned and modified the permission issues in the server.
  • Maintaining SQL Script for creation of Database Objects using VSS Visual Source Safe .
  • Used APPLY clause and also implemented with CROSS and OUTER APPLY to join tables and table variable functions
  • Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks.
  • Update Database Statistics and Re-indexing.
  • Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery.
  • Used the Litespeed to take backups.
  • 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 dead locks.

Confidential

SQL Server 2005 DBA /Developer with SSIS Data Warehouse

  • Perform business analysis, technical analysis, systems design, application development
  • Prepared DFD's Entity Relationship ER diagrams.
  • Restructuring the stored procedure ,designing, coding and developing the same using the SQL
  • Server Integration services SSIS .
  • Developed and deployed packages using SSIS IN SQL2005
  • Transferring the data ETL to Data ware house by SSIS.
  • Extensively worked on Dynamic Management Views in SQL Server 2005
  • Authored, and managed reports using SQL Server 2005 Reporting Services
  • Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
  • Extensively worked on compliance issues.
  • Export or Import data from other data sources like flat files using Import/Export from Bloomberg.
  • Created SSIS / DTS packages to pull data from Oracle and Flat Files.
  • Using SSIS, Experience in data transformation domain.
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilding the indexes at regular intervals for better performance
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases up to 2 Terabytes.
  • Rebuilding the indexes at regular intervals for better performance
  • Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
  • Experience in writing and reviewing T-sql code, maintaining coding standards across the board in all SQL Server environments
  • Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Created indexes to speed the execution of data retrieval queries and stored procedures.
  • Maintaining the database consistency with DBCC at regular intervals

Confidential

SQL Server DBA

  • Database Administrator, Database Programming.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
  • Maintaining the database consistency with DBCC at regular intervals
  • Monitoring SQL server performance using profiler to find performance and dead locks.
  • Managed Disk space, memory and User connections.
  • Performed Database Integrity Checks, updated Database Statistics and performed Re-indexing.
  • Database Development, Database Programming.
  • Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
  • Generated Script files of the databases whenever changes are made to stored procedures or views.
  • Rebuilding the indexes at regular intervals for better performance
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Rebuilding the indexes at regular intervals for better performance
  • Managing the VERITAS net backups.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
  • Complete documentation about the database
  • Monitoring SQL server performance using profiler to find performance and dead locks and blockings.
  • Monitoring the servers using idera third party software.
  • Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
  • Converting DTS packages into SSIS.
  • Recovering the databases from backup in disasters
  • To analyze long running slow queries and tune the same to optimize application and system performance.
  • To set up SQL Server configuration settings.
  • Extensively Involved in writing PL/SQL procedures, functions, triggers packages, Java Procedures and then Multi-threading them through Unix Shell Script.
  • Worked on PL/SQL Packages, Procedures, Objects, VARRAYS, Functions, and REF Cursors for data analysis.
  • Wrote ad-hoc SQL and triggers.
  • Migrated data from the flat file to database using SQL Loader.
  • Worked on User Creations, Roles, Security and Granting Privileges in Oracle.
  • Creation of E-R diagram, OFDs Object Flow diagram as per user requirement.
  • Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.

Hire Now