We provide IT Staff Augmentation Services!

Ms Sql Server Dba Resume

Richardson, TX

PROFESSIONAL SUMMARY:

  • Around 8 years of experience as Oracle and MS SQL Server developer. Involved in the analysis, design, development, testing, and maintenance of complex software systems in both OLTP and OLAP.
  • Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance.
  • Experience in data modeling by using normalization techniques and building referential integrity constraints.
  • Experience in SQL Server installations, database configurations, implementation of backup and recovery, tuning databases, database migrations, log shipping, database mirroring, AlwaysOn, standby databases setup, replication and database security.
  • Experienced in implementing and configuring failover clustering, database mirroring, log shipping and database snapshots to ensure high availability, data protection and disaster recovery.
  • Configured multi servers using SQL protocols like TCP/IP, Named pipe.
  • Production support of very large databases (VLDB) in complex environments.
  • Created SQL Server objects like tables, stored procedures, views, joins, set joins, indexes, functions using T - SQL.
  • Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
  • Expertise in Database Performance Tuning and Optimization of SQL statements using Oracle Hints, Explain plan, Tkprof, SQL*Trace and Table partitioning.
  • Involved in complete ETL processing of extracting the data, transforming the data and Loading the data using
  • SSIS package executables and transformations.
  • Used transformations like data conversion, derived column, conditional split, merge join, look up etc. in SSIS packages. Worked with Agile Programming Methodologies, Waterfall methodologies, Scrum and TDD.
  • Strong experience in Creating, Designing and Processing a Multi-Dimensional Analysis Cubes (Configured Cubes, Dimensions, Measures, MDX Queries, DAX Data mining, Data Source, Data Source Views and following Star and SnowFlake schema) using SSAS.
  • Experience in RDBMS Concepts, Database Management Systems, Database Physical, Logical design, Data Mapping, Table normalization and Data Modeling.
  • Created SSIS packages for data migration from different sources to different destinations like SQL server, oracle, MS access, excel, XML and flat file.
  • Having good knowledge of using variables and expressions in packages. Used variables in execute SQL task script task, for each loop logic, error handling, and precedence constraints.
  • Worked on SSIS packages using execute process task pointing to the .bat file to run the command prompt for transferring the text file to new directory in FTP folder.
  • Experience of scheduling the SSIS packages execution in SQL server agent (Jobs) and tracking the execution of packages and configuring the email notifications through SQL server agent.
  • Having the ability to work in a fast-paced environment, good team player and can work independently and having strong interactive skills to communicate with the end user and development team.

TECHNICAL SKILLS:

Programming Skills: T-SQL, C, HTML, CSS, Python, VB, C#

RDBMS: MS SQL Server, MS Access, Oracle 10g/11g, AWS (Amazon Web Services)

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, SQL Query Analyzer, ETL, SQL Enterprise Manager, Solution Explorer, Analysis Manager, Reporting Server. Monitoring and Other Tools: SQL sentry, SCOM, SCCM, RedGate SQL backup pro, SQL monitor, SQL Compare, SQL Compare, SQL stripes, Service Now, HP Service manager, FileNet, TSM, ISPAC and DACPAC, Visual Studio 2010, 2012. Operating Systems: UNIX, LINUX, Windows7/ NT & Windows 9x and MS-DOS

Systems familiarity: OLTP, DSS, OLAP, MDX

Languages: T-SQL, MS SQL, MDX, C/C++, VB, VBA, HTML, XML

Version Control System:: GIT

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

MS SQL Server DBA

Responsibilities:

  • Worked with Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts.
  • Working on multiple database upgrades from SQL server 2005/2008 to SQL server 2012/2014(Hekaton)
  • Engineering and designing DR setup for upgraded databases like Mirroring and always on availability groups
  • Working on installing and configuring SCOM for monitoring 250 SQL server instances and 3500 database environment
  • Working on Data center SAN migration from Hitachi to EMC
  • Building multiple node clusters for new heavily used OLTP application
  • Working on multi TB SharePoint database migration from SP 2010 to SP2013
  • Installation, administration and support of FileNet P8 5.2 applications IBM content collector, IBM content
  • Navigator ICN, IBM content integrator, etc,MS SQL.
  • Work with content metadata and content security
  • Configuring FileNet user interface for business solutions
  • Day - to-day monitoring, problem resolution and root cause analysis
  • Consults and provides technical support with clients and other technical staff on FileNet design, taxonomy, implementation, or maintenance issues
  • Worked with various tools like Index Tuning Wizard, database engine tuning advisor, SQL Profiler, and Windows
  • Performance Monitor for Monitoring and Tuning Server Performance.
  • Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
  • Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages. Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
  • Built the automated ETL system for the Group Practice data mapping by utilizing the Lookup, slow changing dimension and developed C#/ VB.NET in script task and script component in SSIS.
  • Performed transformations like Conditional Split, Sorting and included data about the environment using the Audit Transformation.

Environment: MS SQL Server 2012/2014, DTS, SSIS,SQL Sentry, SCOM,SCCM, Java, SQL Server Business Intelligence, Oracle, Teradata, Windows 2003/2008/2012 , BizTalk Server, Share point, FileNet, ITM, TSM, WebLogic, Web Methods, AWS, Azure and Power shell.

Confidential, Harrisburg, PA

SQL Server DBA

Responsibilities:

  • Working on upgrades from SQL Server 2005/2008 to newer versions as part of data center migration.
  • Configuring and administering SQL server 2012 Always On availability groups.
  • Working on installing and configuring high availability and DR solutions for share point databases.
  • Working on application issues and performance tuning of SQL Scripts and Stored Procedures.
  • Configuring, deploying and administering SSIS and SSRS.
  • Experience on automating data refreshes from prod to lower environments and suggested Disk Capacity, Processors and Memory based on the Capacity planning.
  • Daily operational tasks like Incidents, user configuration and change management through ServiceNow. 24*7 on - call rotation
  • Creating and Maintaining Users roles groups and granting the privileges to users, groups and maintaining security up to date.
  • Created and monitored Database maintenance plans and maintenance jobs for checking database integrity, data optimization, rebuilding indexes and updating statistics.
  • Worked extensively on Database space management, performance monitoring and alert management.
  • Working on all database related incidents, access requests and change requests.
  • Monitoring and Managing internal DB proactive reports like dormant account check, terminations, DB baseline checks
  • Installing SQL Server service packs and patches on standalone and clustered servers of Prod, Development, QA and DR environments.
  • Experience in creating weekly and daily customized server level maintenance jobs.
  • Supported the very critical Prod databases with 24x7 on call availability.

Environment: MS SQL Server 2000/2005/2008/2012 , SSIS, SSRS, DTS, SQL Ignite, Java, SQL Server Business Intelligence, Oracle, TFS, SharePoint, Windows 2003/2008/2012 .

Confidential, Albany, NY

SQL Server DBA(SSIS, SSAS and SSRS)

Responsibilities:

  • Worked on Full life cycle development (SDLC) and was involved in all stages of development.
  • Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and SQL joins for applications.
  • Implemented different types of constraints on tables.
  • Used highly complex T - SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules. Optimized queries tuned and monitored server performance using SQL Profiler.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Developed SSIS solution for developing a fully-fledged data warehouse solution.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
  • Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like
  • Execute SQL Task, Data Flow Task etc. Identified and defined Fact relationships in SSAS.
  • Responsible for creating the reports based on the requirements using SSRS 2012.
  • Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
  • Worked with RDBMS objects such as tables, views, stored procedures, and functions in MS SQL Server
  • Management Studio (SSMS) to make SSIS packages effective.
  • Developed test-driven development (TDD) strategy guiding use of the Nunit testing framework.
  • Expert within VBA, SQL Server SSIS, and SQL because test scripts included this information.
  • Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
  • Deployed the generated reports directly on the client's workstation.
  • Explored and used many enhancements of Power BI in current reports like Content pack and direct connection to databases like SSAS. Involved in writing scripts for the client s requirements for reporting purposes.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SSAS and Power BI for reporting.
  • Worked on building queries to retrieve data into Tableau from SQL.
  • Analyzed the existing reports, cubes and dashboards and prepared the use cases for Tableau visualizations.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. Implemented the calculations to aggregate physical measures.
  • Involved in Data Modelling of variant Data and integrating the data into existing EDW models.
  • Monitored mainframe production and test jobs, including the critical overnight ODS data exchange processes.
  • Implementing Dashboards and Scorecards using Microsoft Performance point Server and integrated with share point. Monitored production and test jobs for Operational Data Store (ODS) distributed environment.

Environment: MS SQL Server, SSIS, SSRS, SSAS, SSDT, Visual Studio, MS Excel, T-SQL, C#, Window 7, TFS.

Confidential, Albany, NY

SQL Server/BI Developer

Responsibilities:

  • Worked on Full life cycle development (SDLC) and was involved in all stages of development.
  • Worked as a developer in creating complex stored procedures, Triggers, Functions, Indexes, Tables, Views and
  • SQL joins for applications. Implemented different types of constraints on tables.
  • Used highly complex T - SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
  • Optimized queries tuned and monitored server performance using SQL Profiler.
  • Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
  • Developed SSIS solution for developing a fully-fledged data warehouse solution.
  • Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
  • Performed data conversions from SQL server to flat file using SSIS. Created packages that implements tasks like
  • Execute SQL Task, Data Flow Task etc. Identified and defined Fact relationships in SSAS.
  • Responsible for creating the reports based on the requirements using SSRS 2012.
  • Involved in writing Query for generating drill down reports, identified and worked with the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
  • Worked with RDBMS objects such as tables, views, stored procedures, and functions in MS SQL Server
  • Management Studio (SSMS) to make SSIS packages effective.
  • Developed test-driven development (TDD) strategy guiding use of the Nunit testing framework.
  • Expert within VBA, SQL Server SSIS, and SQL because test scripts included this information.
  • Involved in the development of custom stored procedures, functions, triggers, SQL, T-SQL.
  • Deployed the generated reports directly on the client's workstation.
  • Explored and used many enhancements of Power BI in current reports like Content pack and direct connection to databases like SSAS. Involved in writing scripts for the client s requirements for reporting purposes.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SSAS and Power BI for reporting.
  • Worked on building queries to retrieve data into Tableau from SQL.
  • Analyzed the existing reports, cubes and dashboards and prepared the use cases for Tableau visualizations.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. Implemented the calculations to aggregate physical measures.
  • Involved in Data Modelling of variant Data and integrating the data into existing EDW models.
  • Monitored mainframe production and test jobs, including the critical overnight ODS data exchange processes.
  • Implementing Dashboards and Score Cards using Microsoft Performance point Server and integrated with share point. Monitored production and test jobs for Operational Data Store (ODS) distributed environment.

Environment: SQL Server, SSIS, SSRS, SSAS, SSDT, Visual Studio, MS Excel, T-SQL, C#, Window 7, TFS.

Confidential

MS SQL Server DBA

Responsibilities:

  • Played a vital role in migrating all the very large databases from IBM to in - house environment SQL server 2005 using not only all the SQL server native utilities but also many third party tools like In mage clustering agent.
  • Worked on building a very critical high available Clustered environment and make it available through 24x7.
  • Installed SQL Server, its service packs and designed VLDB databases for SAP application in Prod, Dev, QA and DR environment: s.
  • Designed a backup strategy for all the four environments to backup the terabyte databases to data domain with compression and optimized resource utilization with the help of third party tools like LiteSpeed and Msbp.exe.
  • Monitoring logical and physical integrity of all the databases by the maintenance activities like Rebuilding
  • Indexes, Updating statistics and DBCC checks.
  • Trouble shooting all the performance and connectivity issues using Profiler traces and Performance Dashboard
  • Reports.
  • Taken part in very important client discussions and suggested high availability and DR strategies.
  • Created and scheduled multiple jobs to meet all the business requirements and monitoring them through DB mails and Alerts.
  • Hands-on expertise in implementing security by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
  • Worked on AD and LDAP access protocols.
  • Performing test restorations periodically
  • Installed SQLServer2005 performance dashboard reports to monitor and resolve performance problems proactively.
  • Worked with the internal audit team and provided all the data needed for SOX compliance.
  • Supported the very critical Prod databases with 24x7 on call availability.
  • Handling day to day tickets.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, SAP, SSRS 2005, SSIS 2005, SSAS 2005, Microsoft Clustering Services, .NET Framework, Windows 2000/2003 Advance Server, Lite Speed, Quest Foglight Performance Analysis, HP Service manager, VERITAS Net Back Up

Confidential

SQL developer (SSIS/SSRS)

Responsibilities:

  • Involved in gathering requirements from business users and created Functional Specifications, Technical Specs, Design documents and Approach documents. Created SSIS packages to clean and load data to the data warehouse.
  • Involved in reviewing the Investments application and interacting with business users to understand the user requirements. Developed stored procedures to use in SSRS reports using dynamic SQL and T - SQL.
  • Worked with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects. Worked in Agile Scrum with daily stand up meetings and great knowledge in TFS.
  • Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse. Created packages to migrate data from different data sources to data warehouses.
  • Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc. Developed stored procedures to use in SSRS reports using dynamic SQL and T-SQL.
  • Developed SSIS packages using various Control and Data Flow items to Transform and Load Data using SSIS.
  • Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and Modified already existing stored procedures, triggers, views, indexes depending on the requirement. Executed the test cases in Quality Center to ensure the quality of the data migration.
  • Implemented Custom Error Handling (Record Level) by using the Script component to generate custom error messages and redirected the error rows to a staging error table.
  • Used the SSIS Configuration files to make the package connections, variables etc., configurable and maintained the same on Test and Production environments. Developed Complex SSRS Reports involving Sub Reports.
  • Built different types of chart reports using SSRS for the business requirement like Designed and deployed reports with Drill Down, Drill Through, drop down menu options, Sub-reports in SSRS using BIDS.
  • Report parameters included single valued parameters, multi-value parameters that also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
  • Created complex stored procedures to use as datasets for Report Design, to generate Ad Hoc reports using SSRS.

Environment: MS SQL Server 2008, XP, T-SQL, SSAS, SQL Profiler, Microsoft Dynamics, Agile, Report Builder, T-SQL, SSRS, SSIS, Visual Studio 2005/2008, SSDT, VB script XML, Crystal Reports, Excel.

Confidential

SQL BI Developer

Responsibilities:

  • Efficiently used Microsoft SQL server 2005/2008/2008 R2 SQL server management studio.
  • Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis. Elicited business requirements through interviews, surveys, prototyping and observations.
  • Prepared BRDs (Business Requirement Documents) supporting documents containing essential business elements, detailed definitions, & description of the relationships, to analyze and document business data requirements. Reviewed and Analyzed the Business and Functional Requirement Documents.
  • Used SQL server business Intelligence Development Studio to design SSIS packages to transfer data between servers and deploy the data. Scheduled the job to do this task periodically.
  • Designed DTS/SSIS Packages to transfer data between servers, load data into database, and archived data files from different DBMS using SQL enterprise manager/SSMS on SQL server 2005/2008 environment.
  • Generated reports using SQL server Reporting Services, and created user friendly templates, indexes, using xml
  • Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications. Developed SQL queries to validate data in tables based on business requirements.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop - down menu option using SSRS. Extensive use of T-SQL DDL and DML commands for various applications.
  • Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like
  • Stored Procedures, User Defined Functions, Views, TSQL Scripting. Good working knowledge on Agile Projects.
  • Implementing an extra level of security by creating views and creating stored procedures to query the confidential data. Worked in development of ETL, maintained and supported the enterprise data warehouse system.
  • Worked on Back-end in SQL Server development, writing complex queries, stored procedures, views, triggers, cursors, UDFs. Generating reports using linked reports, sub reports and filters in SQL server reporting services.
  • Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.
  • Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.

Environment: Windows server 2005, MS SQL Server 2005/2008, Business Intelligence Development studio (SSRS and SSIS), Microsoft.NET, T-SQL, MS Office Access 2003, VBScript, Erwin and Visio.

Hire Now