We provide IT Staff Augmentation Services!

Senior Sql Server Analyst Resumi,hartford, Ct

Tools/Methods

  • Management Studio
  • SQL Profiler
  • Enterprise Manager
  • Query Analyzer
  • DTS/SSIS, SSAS, SSRS
  • MS SQL Server 2008/2005/2000 /7.0 Oracle, MS Access
  • T-SQL, C, C++, C#
  • ASP.NET, Visual Basic
  • Windows Server 200
  • Windows XP/2000/95/NT

SKILLS INVENTORY

  • Excellent skills in creating Database Objects like Tables, Views, Triggers, Stored Procedures, User Defined Functions and writing complex T-SQL queries.
  • Good experience in Deploying SSIS packages in MS SQL Server 2005 and MS SQL Server 2008.
  • Excellent experience in In-Place and Side-by-side upgrades from SQL Server 2000 to SQL Server 2005.
  • Excellent experience in installation and configuration of MS SQL Server 2008, 2005 & 2000 versions.
  • Excellent experience in maintaining, supporting, monitoring production and test environments.
  • Expertise in planning and implementing MS SQL server security and database permissions.
  • Excellent working experience in Management Studio, Enterprise Manager and Query Analyzer.
  • Experience working with large databases and experience in supporting multiple production database servers.
  • Sound knowledge on database driven application using Visual Basic, ASP in .NET framework.
  • Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Performance Monitor.
  • Experience in Database Backup, Recovery and Disaster Recovery procedures.
  • Hands on experience in migrating DTS packages to SSIS packages.
  • Experience in supporting very large Databases (Terabytes).
  • Experience in Data Modeling (Logical and Physical Design) of Databases, Normalization and building Referential Integrity Constraints.
  • Experience in transforming data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS) and SSIS.
  • Experience in SQL Server Reporting Services (SSRS).
  • Hands on experience in maintenance of Databases, creating roles and managing user permissions, and resolving deadlocks.
  • Experience in investigating and applying necessary SQL Server database service packs and patche

CHRONOLOGICAL SUMMARY OF EXPERIENCE

Senior SQL Server Analyst/DBA

Confidential

  • Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and clustered environments and applied service pack.
  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Hands on experience with developing reports using SSRS.
  • Interacted with Developers in troubleshooting application and Report Developing.
  • Involved in writing the Scripts Using Automate.
  • Involved in installing SQL Server 2005 on Development, Production and WTC (Testing) machines.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Migrated data from Aria V7 to Aria V11.
  • Developed a data cleansing and validating process.
  • Developed message specification rules for HL7 interfaces and transformation of batch flat file CSV-XML(CDA) interfaces to HL7 (e.g. MDM) and parsing. Verify any XML "in-scope" document rendering process for all systems.
  • Design tactical solution for a conceptual & logical interoperable Enterprise SQL Server database repository that is based on the Aria Med Onc v11 application's data base structure.
  • Monitoring and scheduled jobs on production and staging environment.
  • Involved in troubleshooting all the performance issues for different database applications.

Senior SQL Server Analyst/DBA

Confidential

  • Installed SQL server 2008, 2005 and SQL Server 2000 and applied service pack.
  • Installed HP OVPI on different servers.
  • Extensive experienced with HP OVPI (Open View Performance Insight) in an HP OVPA environment.
  • Management, monitoring, and implementation of a mutli-terrabyte HP OVPI database structure (multiple satellites, central, and archive servers).
  • Building of complex HP OVPI reports.
  • Customization of HP OVPI report packs.
  • Building of complex HP OVPI reports.
  • Integration of non-HP data into OVPI and the report packs (i.e. Remedy CMDB).
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Transformed and manipulated the data by using SSIS transformations and tasks.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Involved in daily maintenance of SQL servers.
  • Fixing Performance issues by Indexing, Query Optimization etc.
  • Used database consistency checks using DBCC utilities.
  • Scheduled Jobs and Alerting using SQL Server Agent.
  • Involved in troubleshooting all the performance issues for different database applications.
  • Automated monitoring all the daily failed jobs in all the servers using system database, DTS and SQL Mail.
  • Monitoring and scheduled jobs on production and staging environment.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Performed data conversion from flat file into a normalized database structure.
  • Created DTS package to export and import data from SQL Server to text files.
  • Developed scripts for batch processing.
  • Migrated data from Access 2003 to SQL server 2005.
  • Created the DTS (SSIS) packages and scheduled them.
  • Responsible for writing SQL Transactions, Creation and Enhancement of Stored Procedures.
  • Expert in Reporting Services.
  • Generated reports using MS Reporting services.

Environment: MS SQL Server 2008/2005, MS Access 2003, SSIS, DTS.

Senior SQL Developer

Confidential

  • Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and clustered environments and applied service pack.
  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Hands on experience with developing reports using SSRS.
  • Interacted with Developers in troubleshooting application and Report Developing.
  • Involved in writing the Scripts Using Automate.
  • Involved in installing SQL Server 2005 on Development, Production and WTC (Testing) machines.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created logins and users with specific roles and permissions as per security rules.
  • Created daily database backup and recovery procedures for Development, WTC (TESTING) and Production environments.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Optimized Stored Procedures and long running queries using query-optimization techniques.
  • Provided 24 x 7 Production support for the database using VM Ware and application issues.

Environment: Windows 2003 Server, MS SQL Server 2008/2005, MS SQL Server 2000, BIDS, SSIS, DTS.

Senior SQL Server DBA/Developer

Confidential

  • Installed SQL server 2008, 2005 and SQL Server 2000 and applied service pack.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Transformed and manipulated the data by using SSIS transformations and tasks.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Involved in daily maintenance of SQL servers.
  • Fixing Performance issues by Indexing, Query Optimization etc.
  • Used database consistency checks using DBCC utilities.
  • Scheduled Jobs and Alerting using SQL Server Agent.
  • Involved in troubleshooting all the performance issues for different database applications.
  • Automated monitoring all the daily failed jobs in all the servers using system database, DTS and SQL Mail.
  • Monitoring and scheduled jobs on production and staging environment.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Performed data conversion from flat file into a normalized database structure.
  • Created DTS package to export and import data from SQL Server to text files.
  • Developed scripts for batch processing.
  • Migrated data from Access 2003 to SQL server 2005.
  • Created the DTS (SSIS) packages and scheduled them.
  • Responsible for writing SQL Transactions, Creation and Enhancement of Stored Procedures.
  • Expert in Reporting Services.
  • Generated reports using MS Reporting services.

Environment: SQL Server 2008/2005/2000 , SSIS, SSRS, Data Ware Housing, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

Senior SQL Server DBA/Developer

Confidential

  • Installed SQL server 2008, 2005 and SQL Server 2000 and applied service pack.
  • Interacted with application team at the time database migration from SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2005, 2008.
  • Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio and updated in Visual studio 2008.
  • Developed, monitored and deployed SSIS packages.
  • Involve in Migrating the data from MS Access to SQL server.
  • Involved in claims department to load all claims and fix the problems 24*7.
  • Interacted with Developers in troubleshooting application and database issues mostly related to claims.
  • Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Transformed and manipulated the data by using SSIS transformations and tasks.
  • Responsible in Monitoring and Troubleshooting SQL Server Performance issues.
  • Created and managed users, roles and groups and handled database security.
  • Created Triggers to enforce data and referential integrity.
  • Created various Weekly and Monthly reports showing detailed information.
  • Used ETL tool to communicate with the many different relational databases and read the various file formats used throughout in the organization.
  • Created SQL scripts for tuning and scheduling.
  • Performed data conversion from flat file into a normalized database structure.
  • Created DTS package to export and import data from SQL Server to text files.
  • Developed scripts for batch processing.
  • Migrated data from Access 2003 to SQL server 2005.

Environment: SQL Server 2008/2005/2000 , SSIS, SSRS, Data Ware Housing, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

SQL Server DBA/Developer

Confidential

  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Interacted with application team at the time database migration from SQL Server 2000 to SQL Server 2005, SQL Server 2005 to SQL Server 2008.
  • Hands on experience using SDLC.
  • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Used ETL tool to communicate with the many different relational databases and read the various file formats used throughout in the organization.
  • Created SQL scripts for tuning and scheduling.
  • Performed data conversion from flat file into a normalized database structure.
  • Created and managed users, roles and groups and handled database security.
  • Created Triggers to enforce data and referential integrity.
  • Logical and Physical design of database for projects on basis of user requirements using ERWIN.
  • Created various Weekly and Monthly reports showing detailed information.
  • Responsible for creating the reports basing on the requirements using SSRS 2005.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Created various Database Objects - Tables, Indexes, Views, and Roles.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
  • Troubleshooting various issues encountered while converting existing DTS Packages to SSIS Packages.
  • Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
  • Documented all the steps and procedures for future references.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created logins and users with specific roles and permissions as per security rules.
  • Created daily database backup and recovery procedures for Development, Testing and Production environments.
  • Deploying database objects from development/testing environment to production environment.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.

Environment: Windows 2003 Server, MS SQL Server 2008/2005/2000 , ERWIN, SSRS, SSIS, BIDS, SSIS, DTS.

SQL Server DBA/Developer

Confidential

  • Installed SQL server 2008, 2005 and SQL Server 2000 on standalone and clustered environments and applied service pack.
  • Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
  • Interacted with application team at the time database migration from SQL Server 2000 to SQL Server 2005.
  • Interacted with Developers in troubleshooting application and database issues.
  • Highly used T-SQL for developing complex Stored Procedures and Triggers.
  • Involved in installing SQL Server 2005 on Development, Production and WTC (Testing) machines.
  • Converting existing DTS Packages to Integration Service (SSIS) Packages using DTS Xchanger tool.
  • Troubleshooting various issues encountered while converting existing DTS Packages to SSIS Packages.
  • Deployed SSIS packages to MSDB database and file system using manifest file and the wizard utility in SQL Server 2008.
  • Created and deployed SSIS packages and scheduled jobs on daily, weekly and monthly basis.
  • Interacted with concern application team in fixing the problems when ever needed.
  • Created logins and users with specific roles and permissions as per security rules.
  • Created daily database backup and recovery procedures for Development, WTC (TESTING) and Production environments.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Monitoring all activities of the server including monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
  • Involved in setting up database mirroring for production server
  • Configured replication methods like snapshot, transactional and merge replications.
  • Monitoring and scheduled jobs on production and staging environment.
  • Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS.
  • Used the Execution Plan to improve the optimization of the T-SQL code.
  • Resolving performance related issues to Blocking, Deadlocks and long running queries
  • Optimized Stored Procedures and long running queries using query-optimization techniques.
  • Provided 24 x 7 Production support for the database using VM Ware and application issues.

Environment: Windows 2003 Server, MS SQL Server 2005, MS SQL Server 2000, BIDS, SSIS, DTS.

SQL Server Developer

Confidential

  • Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
  • Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Use the SQL Analyzer and Profiler for studying the SQL statements and procedures.
  • Use the SSAS to discover relationships and dependencies, finds causation, and predicts likely outcomes based upon trends and patterns.
  • Used T-SQL for programming for stored procedures and queries.
  • Manually copied and pasted the Active X script from DTS to SSIS.
  • Used SSAS Cube to analyze data of related measures and dimensions.
  • Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
  • Logical and Physical design of database for projects on basis of user requirements using ERWIN.
  • Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
  • Responsible for creating the reports basing on the requirements using SSRS 2005.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Created various Database Objects - Tables, Indexes, Views, and Roles.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Performed Full and Differential backup with bulk-logged recovery models.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
  • Involved in extracting the data using SSIS from OLTP to OLAP.
  • Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
  • Migrated data from MS Access to SQL Server.

Environment: SQL Server 2008/2005, SSIS, SSRS, Data Ware Housing, Visual studio 2008, MS Visio 2007, Enterprise Edition, XML, MS Access 2003.

SQL Server Developer

Confidential

  • Managed and maintained the entire release of the project.
  • Involved in requirement gathering, analysis and design.
  • Imported data into SQL Server 2005.
  • Created databases, tables.
  • Created the SSIS packages and scheduled them.
  • Responsible for Design and Normalization of the database tables.
  • Extensively used T-SQL queries to filter data.
  • Wrote Triggers and Stored Procedures to capture updated and deleted data from OLAP systems.
  • Gathered user requirements.
  • Used ETL tools to maintain the quality of data and also to improve the metadata capabilities.
  • Solid understanding of data warehousing, OLTP and OLAP concepts. Performed data extracts.
  • Development and implementation of experience in development and implementation of Data Warehousing Applications using Cognos.
  • Create alerts system in case of SQL server job failure.
  • Performed database management, performance monitoring and tuning.
  • Implemented database mirroring.
  • Created SSIS packages to transfer the data and assigned the packages to jobs and scheduled the jobs.
  • Hardware and software troubleshooting/ upgrades.
  • Setup Operations Reports using SQL Server Reporting Service (SSRS).
  • Created reports and sub reports using report builder and wizard.
  • Successfully completed QA.

Environment: SQL Server 2005, SSIS, SSRS, MS Visio 2007, Data Ware housing, Enterprise Edition, XML, Web Services, JavaScript, MS Access 2003

SQL Server Developer

Confidential

  • Gathered user requirements.
  • Analyzed and designed of software and database solutions.
  • Updated functional specification and technical design documents.
  • Designed database objects, normalize data base objects using OLTP
  • Developed stored procedures, functions and triggers.
  • Developed scripts to move data from the flat files into the tables.
  • Created DTS package to export and import data from SQL Server to text files.
  • Developed scripts for batch processing.
  • Used ETL implementations to store an audit trail on positive and negative process runs.
  • Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.
  • Used HIPAA Rule for personal health information held by covered entities and gives patients an array of rights with respect to that information.
  • Created reports as per the requirement needs using Crystal reports.
  • Created views as per design needs.
  • Supported the front-end application developers with their queries.
  • Responsible for tuning procedure and database objects.

Confidential: MS SQL Server 2000, MS Access, SQL Query Analyzer, Enterprise Manage, DTS, SQL Developer, Visual Basic 6.0, Crystal Reports 8.5

SQL Server Developer

Confidential

  • Coordinating and synchronize with Management by working as a dev/admin on MS SQL Server 2000, MS Access databases (using DTS, T-SQL, scripts, stored procedures and views).
  • Worked as a developer in creating Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for applications.
  • Developed T-SQL code for the application.
  • Design and implementation of stored procedures and triggers for automating tasks.
  • Managing the security of the servers (Logins and users).
  • Managing the changes and managing the service pack installation as well as managing the server wide changes.

Environment: SQL Server 2000, Query Analyzer, SQL Profiler, Windows 2000 Server, Import & Export Data.

Hire Now