SUMMARY

• 8+ years of experience as SQL server 2016/2014/ 2012/2008 R2/2005 DBA with Banking, Financial services and Health Care sectors.
• Experience in supporting Very Large databases (VLDB) and troubleshooting.
• Experience in writing Stored Procedures, User Defined Functions, Cursors and Triggers.
• Experience in ETL data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Worked with Windows Server 2008 Enterprise Edition, Windows 2003 Advanced Server, Windows 2000 Server and Windows NT.
• Experience in data architecture.
• Maintained security for databases (creating logins for users, roles, and assigning permissions to them).
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Expert in performance tuning and handling blocking situation and dead lock situations.
• Used third party Quest tools like spot light, fog light and Litespeed for backing up large databases.
• Played a crucial role Migrating SQL Server 2012 to SQL Server 2014.
• Experience with concepts in SQL Server 2012 such as data partitioning, online indexing, DDL triggers, DMV, DMF, DTA and performance dash board.
• Experience in Creating Jobs (Both cron and non - cron), alerts and automating them.
• Expertise in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Intensive experience in monitoring database performance using SQL Profiler and Windows Performance Monitor.
• Experience in PowerShell Development.
• Deep knowledge in Data Modeling (logical modeling and physical modeling) using Erwin.
• Expertise in Administration, Development, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Experience in high availability SQL Server solutions, which include Log shipping, Replication, Mirroring and SQL Server clustering.
• Experience in Database Mirroring as disaster recovery solution.
• Skilled with Integration, Reporting and Analysis Services.
• Skilled in developing MSSQL Server 2012 & 2008.
• Administering SAP Products.
• Extensively used LINQ and ORM tools like Entity Framework to exchange data between web applications and database objects.
• Creation of Database system, capacity and storage planning monitoring the parameters through DBCA utility and manual design.
• Experience in monitoring SQL Server 2012 as a part of Higher Availability Solution for the Production Environment.
• Strong experience in T-SQL Programming in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables, indexes and complex queries.
• Experience in Tuning SQL queries and improving the performance of the Database.
• Proficient in Data Modeling (Logical and Physical Design of Databases) and creating highly flexible database architecture.
• Experience in SQL 2008 and 2012 Servers database administration (Index Tuning and performance troubleshooting) and Setting up SQL Mirroring.
• Sql server Reporting and analysis services
• Working in Application Support space. Familiarity with Incident management.
• Decent understanding of network shares.
• Customizing reports for business op.
• Strong analytical, and data management skills.
• Decent experience in FoxTrot Scripting and Monarch.
• Always On, Windows clustering.

TECHNICAL SKILLS

Operating Systems: Windows 8.1/7/XP/NT4.0, Windows

RDBMS/DBMS: SQL Server 2016, 2014, 2012, 2008 R2, 2005, MS Access, Oracle, My SQL, DB2

Languages: T-SQL, C #, Perl, SQL, PL/SQL, XML, HTML, DHTML, Asp.Net, Java Script, VB Script

Web Technologies: ASP, ASP.Net, VB.Net, ADO.Net, CSS, Technologies includeDB2 UDB LUW v7.x, v8.x, v9.x,v9.7,AIX v5.x, Sun Solaris, Linux, BMC Patrol, DB Artisan, Control Center, DB2 client, DB2 Connect, Performance Expert, Optimal Performance Manager (OPM),Quest,db2support, db2move, db2advis, db2batch, db2pd, Visual Explain, export/import/load, Tivoli Storage Manager (TSM),Oracle, PERL, Shell Script.

Monitoring Tools: BMC Patrol, SQL Server Profiler, Performance Monitoring

Version Control: MS Team Foundation Server (TFS), VSS, CVS, PVCS, ClearCase

Reporting tools: Business Objects/Crystal Reports, SSRS (Report Builder)

MS-Office: Word, Excel, Access, Outlook, Outlook Express, Power point.

Data migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

Senior SQL Server DBA

Responsibilities:

• Installing MS SQL Server 2008 R2 and 2012, 2014 & 2016 updating with latest service packs and security patches.
• Migration experience fromMS SQL Server 2000toMS SQL Server 2005/2008,MS SQL Server 2005toMS SQL Server 2008.
• Exceptional understanding of inheriting casting and converting PL/SQL objects.
• High proficiency in developing Oracle PL/SQL packages.
• Experience in creating SSIS packages. Experience inDTS MigrationandMetadata.
• Installed and configured MySQL on Linux and Windows environments.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Effectively configured MySQL Replication as part of HA solution.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• CreatedPL/SQL scriptsto extract the data from the operational database into simple flat text files usingUTL FILEpackage.
• Initially used Jasper ETL Pro for doing the same later on moved to talend Integration Suite (TIS) for developing the ETL jobs.
• Jasper Reports - Involved in gathering report requirements and developing the same.
• Scheduling of the reports using Jasper Server.
• Jasper UI - Involved in changing the Jasper look and feel.
• Using Jasper latest UI framework, we changed the look and feel of jasper so to match application integrity.
• Involved in installation of Jasper BI Server 4.1.2, JETL 4.1.2, TIS 4.1.2
• Creation of database objects liketables, views, materialized views, procedures and packagesusing oracle tools likeToad, PL/SQL DeveloperandSQL* plus.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Management:Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Developing MSSQL Server 2012 & 2008 servers.
• Installing and maintaining Microsoft SQL Servers
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Configuring Snapshot and Transactional Replication to replicate date to different environments.
• Creating and modifying Stored Procedures, Functions, triggers. Backup and restore of databases as required.
• Designed a backup plan. Created Maintenance Plans to make sure the database does not encounter any issues.
• Experience in data architecture modelling.
• Developed analyses for, Ops Reviews, management reports, business cases, strategic planning, and ad hoc quantitative and qualitative analyses.
• Developing MSSQL Server Reporting Services(SSRS).
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAScubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Migration of Existing Application toAWScloud.
• Provide Level 3 NetApp SAN/NAS support to field and onsite personnel to major clients.
• Automated RegularAWStasks like snapshots creation using python scripts.
• MonitoringAWSInstances regularly using ops view and New Relic tools.
• Installing configuration and maintenance of Web Servers (apache), App Servers Perform research onawsresources or tools to recommend to clients.
• Applied SAP correction notes as per the SAP and Developers requirements.
• Monitored SAP systems and troubleshooting any issues related to the problem.
• Managing DB2 UDB databases on 30 Unix servers, sizes up to a few hundreds GBytes. Troubleshoot all database related problems.
• Administered over 1PB of NetApp storage utilizing both File and Block based volumes.
• Created StudioShell - an open source PowerShell automation environment for Visual Studio.
• Integrated disparate technologies with Microsoft PowerShell - Entity Framework, Redis, MongoDB, ASP.NET Membership, SQLite, OData, etc.
• Created SeeShell - a data visualization module for PowerShell environments.
• Extensively used LINQ and ORM tools like Entity Framework to exchange data between web applications and database objects.
• Using Sql Server 2012 database as back-end along with ADO.NET Entity Framework and Linq to access the database tables.
• Provided DBA 24x7 on call Support for company wide UDB Production databases. Responded and troubleshoot all database related issues and had a 100% on-time resolution for all PROD and DR issues. As a results no Production or DR database had any downtime throughout the years.
• Managing DB2 UDB databases on 30 Unix servers, sizes up to a few hundreds GBytes. Troubleshoot all database related problems.
• Development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting usingBusiness Objects XI R2/R3, Crystal Reports 2008, Adobe Flex 3 and Xcelsius 2008.
• Replication with Slony and Slony log shipping.
• Table Partitioning for 100+ million record tables.
• Authorising and maintaining slony table publish scripts.
• Postgres Master to warm Standby failover (PostgreSQL 8.4).
• Oncall for various PostgreSQL assistance.
• Shadow table development.
• Responsible for company wide DB2 UDB upgrade planning and design, including from version 7.x to version 8 and from version 8.x to version 9.x. Function as DB2 Engineering DBA.
• Presented upgrade plans including comprehensive Fallback Plans to application and business users.
• Carefully designed and planed the upgrade strategies including changing the database file system layout during the upgrade, separated the database file systems, file systems for tablespaces and the instance owner’ Confidential file system which had been all under one file system in old version. Database performance was improved as a result. Separating the file systems enforced the UDB database standard practice and it also simplified tablespace and file system maintenance.
• Experience in all the phases of SDLC.
• Dimensional and Relational databsae modelling.(Logical and Physical)
• Experience in designing and capacity planning larger scale multimode servers
• Optimized queries for better performance. Designed disaster recovery model.
• Configuring change data capture (CDC) at database level to capture the Changes on the tables.
• Using Profiler to identify long running queries and optimize them.
• Created users and designed security model. Created tables and views.
• Experience at providing 24x7 on call support for production environment and responding to off hour emergencies, generating solutions rapidly and work well under pressure.
• Developed UI using HTML 5, Bootstrap, Jquery, and JSP for interactive cross browser functionality.
• JQuery to select and manipulate HTML elements and also CSS manipulation.
• Used jQuery mainly for adding several functionalities to the application (calendar, tooltips,popover).
• Created and upgraded SSIS packages for creating files and for ETL process.
• Worked on comparing database, database objects between two environments using schema compare tool in Visual Studio 2008.
• Implemented HA(High Availability) using Double take in heterogeneous environment.
• Worked on Always On HA feature
• Windows clustering, performance tuning
• Working extensively on SQL Server Integration Services (SSIS) and Implementing Snapshot Isolation in SQL Server 2012
• Used Online Indexing and online Restoring in SQL 2012. Implemented new topics like CLR integration on Development server.
• Solving the Bugs Reflected by the Testing team. Migrated DTS and SSIS packages from SQL Server 2008 to SSIS SQL server 2012.
• Evaluated data storage considerations to store databases and transaction logs. Involved in Source Data Analysis, analysis and designing mappings for data extraction.
• Data Backups using AVAMAR

Environment: MS SQL Server 2014/2012/2008 R2, T-SQL, SSIS, SSRS, Report Builder, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering Service Desk BMC, Double Take, Team Foundation Server. Windows 8.1/ 7/XP, SSMS, DTS, SQL profiler, VSS 6.0 C, HP SAN, Magic.

Confidential, Irving, TX

SQL Server DBA

Responsibilities:

• Maintained SQL Server 2008 R2/2012 versions.
• Conducted a WebFOCUS software assessment to upgrade to latest version of WebFOCUS 8
• Installing and maintaining Microsoft SQL Server software.
• Involved in migrating share point from one server to the other.
• Involved in migrating share point from one server to the other.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Ability to carry out security tasks at network level such as block/unblock TCP/IP ports through firewall on both Linux and windows and block/unblock remote access to MySQL server.
• Used iReport for creating the panels and jasper dashboard for consolidation.
• Management of Jasper server Production and development.
• CAS security implementation on jasper
• BI Solution development on iReport using AS/400 as a backend.
• Jasper integration with Joomla
• BI solution development like Jasper Reports, Analysis (OLAP cube) and Adhoc Reporting using Jasper Enterprise Edition.
• Extensively used the advanced features of PL/SQL likeRecords, Tables, Object typesandDynamic SQL.
• Performed MySQL Replication setup and administration on Master-Slave and Master-Master.
• Automated Data Import Script using shell scripting, PHP, MySQL and regular expressions.
• MySQL database backup and recovery strategies and Replication and synchronization.
• MySQL processes and queries optimization. Exported and Imported database 10g objects from development to production.
• Involved in the continuous enhancements and fixing of production problems.Designed, implementedandtunedinterfaces and batch jobs usingPL/SQL. Involved in data replication and high availability design scenarios withOracle Streams. DevelopedUNIXShellscriptsto automate repetitivedatabaseprocesses.
• Worked onSQL*Loaderto load data from flat files obtained from various facilities every day. Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Created PL/SQL scripts.
• Tested and debugged Oracle PL/SQL packages.
• Assisted in converting PowerBuilder code to PL/SQL.
• Migrated Oracle 9i databases to MySQL using the MySQL Migration Toolkit.
• Involved in migration and re-engineering of MySQL database from 4.1 to MySQL 5.1.
• Data migration usingDTSservices across different databases like Oracle, MS access & flat files.
• Configured SQL server mirroring on SQL Server 2012 databases.
• Developing MSSQL Server 2008 servers.
• Managed a large number of NetApp storage appliances locally. The job also allowed users to work with a lot of high-end technologies.
• Managed a large number of NetApp storage appliances locally and D.R. Sites. The job also allowed users to work with a lot of high-end technologies.
• Experience in supply chain management.
• Expert in creating Star schema cubes usingSSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Involved in creating calculated members, named set, advanced KPI’ Confidential for theSSAScubes.
• Involved in End to End migration of 15 SQL Server 2008 instances to SQL Server 2012.
• Configured on 4 nodes in SQL Server 2012. Installed and maintained few Sql server 2012 instances.
• Experience using Red gate SQL Server backups and restores.
• Developing MSSQL Server Reporting Services(SSRS).
• Experience in Telemetry.
• Experience in all the phases of SDLC.
• Experience in Telemetry.
• Worked on front end pages that were developed in a professional manner usingHTML, CSS, JavaScript, and JQUERY.
• Developed client side validation code usingJavaScript and JQUERY.
• Extensively used/modifiedJQUERYto performAJAXcalls for creating interactive web pages onJSONresponse.
• Responsible for the technical monitoring, support, and administration of the SAP system.
• Updates of SAP kernel, SAPJVM.
• Worked on SAP PI connectivity issues in the current landscape.
• Worked onintegration of SAP NetWeaver BI and SAP NetWeaver Portal
• Middle Ware ADO.NET, Web services, ADO.NET Entity Framework, ASP.NET Web API.
• Worked on PostgreSQL database for virtual machine management.
• Developing codes in bash for automated backups of cloud servers.
• Setup hot standby for a PostgreSQL 9.1 Server
• Performed database and website migrations to new servers.
• Created linked servers between two SQL Server 2012 servers.
• Setting up Transactional Replication/DTS SSIS Database Mirroring Log Shipping using Double Take in heterogeneous environment.
• Enabled regulatory product approval by implementing security and instrumentation services that comply with established regulatory protocols and standards (e.g., GAT3) using C#, Remoting, and Powershell.
• Worked in the Information Technology field gathered and analyzed business requirements and produced specification documents for new project requests. Developed ad-hoc queries and reports for clients and provide analytical support and recommendation as necessary. Acted as liaison between business unit and report developer to develop, communicate and modify existing report.
• Monitoring and troubleshooting various servers and issues respectively.
• TSQL database querrying, triggers, stored procedures, views.
• Creation of Database system, capacity and storage planning monitoring the parameters through DBCA utility and manual design.
• Involved in performance tuning and query optimization.
• Analyzing long running queries and tuned the same to optimize application performance.
• Involved in disaster recovery techniques like Clustering, Mirroring, Log shipping.
• Used Bulkinsert, BCP and database consistency checks using DBCC command.
• Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Installed, authored, and managed reports using SQL Server 2012 Reporting Services.
• Review T-SQL code to verify it meet standards for both performance and error handling according to DBA standards.
• Experience in defining database architecture, database testing
• Created Logon trigger to validate users connecting through different applications.
• Used Performance Monitor/SQL Profiler to analyze long running /slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2008R2/2012 with clustering, Replication, T-SQL, Windows 7/XP 64-bit servers, SSIS, Red Gate Power Shell, EMC,.NET4.

Confidential, Herndon, VA

SQL Server Developer/DBA

Responsibilities:

• Installed MS SQL Server 2008 R2, 2012, updating with latest service packs and security patches.
• Installing and maintaining Microsoft SQL Server software
• Managed Databases spread across multiple servers in Production, Development, staging & testing environments.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2000 & 2005(SSAS).
• DevelopedMulti dimensional Objects(Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• DesignedDimensional ModelingusingSSASpackages for End-User.CreatedHierarchiesin Dimensional Modeling.
• Used OracleJDeveloperto support JA Built complex queries using SQL and wrote stored procedures using PL/SQL in Various API’ Confidential like Java, .Net and Hierarchical databases like Oracle and Access.
• WroteSQL, PL/SQL, SQL*Plusprograms required to retrieve data using cursors and exception handling.
• Developed and modifiedtriggers, packages, functionsandstored proceduresfor data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Created and modifiedSQL*Plus, PL/SQLandSQL*Loader scriptsfor data conversions.
• Wrote conversion scripts usingSQL, PL/SQL, stored procedures, functionsandpackagesto migrate data from SQL server database to Oracle database.
• Developing MSSQL Server 2012 & 2008 servers.
• Data migration using bulk copy program and DTS fromOracle Databasesand Flat files.
• Migrated and testedDTSpackages toSQL Server 2005 Integration Services.
• Fixed and rebuilt manySSISpackages during the migration.
• Experience in designing and capacity planning larger scale multimode servers.
• Developing MSSQL Server Reporting Services(SSRS).
• Worked extensive with database design team and development team for database design and implementation, used Erwin and Visio for database design and SQL 2008 for development.
• Implemented the Data Partitioning for large tables in SQL Sever 2008.
• Creation of Database system, capacity and storage planning monitoring the parameters through DBCA utility and manual design.
• Wrote application front end with HTML, JSP, Ajax, Struts Tag-libraries, custom JSP tags for role-based sorting and filtering and used JavaScript validations to validate the fields of the user registration screen and login screen.
• Developed applications in AngularJS and deployed into development, test and production environment successfully.
• Handled all the client side validations, slide show, hide and show controls, dropdown menus and tab navigation usingJQUERY.
• Wrote code to fetch data from Web services usingJQUERY AJAX via JSONresponse and updating the HTML pages.
• Modified Struts configuration files as per application requirements and developed Web services for non-javaclients to obtain user information.
• Experience in all the phases of SDLC.
• Created custom log-shipping to manage Disaster Recovery and Production Support restores.
• Scheduling the DBCC commands to run daily, weekly basis. Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification.
• Expert in using DMV’ Confidential, Performance dash board, Mirroring, database snapshot.
• Worked file and file group Backup/Restore. Maintained the database consistency with DBCC at regular intervals.
• Conducted change management assessments and statistical analyses that improved the efficiency and effectiveness of the client' Confidential performance.
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Administering SAP Products.
• Got the requirement from end user. Did data mapping, know what information the end user need, created tables with various constraints including primary key, foreign key, etc.
• Dimensional and Relational databsae modelling.(Logical and Physical).
• Involved in logical designing and physical designing the databases using Erwin.
• Performing DB Security, creating users, roles, and assigning permission.
• Worked on SQL server 2008 T-SQL new features such as MERGE statement and Date time offset Data type.
• Involved in performance tuning and query optimization.
• TSQL database querrying, triggers, stored procedures, views
• Experience in defining database architecture, database testing
• Implemented new T-SQL features added in SQL Server 2008R2 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Extensively worked on SQL Server Integration Services (SSIS).
• Implemented new topics like CLR integration on Development server.

Environment: MS SQL server 2005/2008R2/2012, Windows 7/XP, VB, .Net, Enterprise manager, Query Analyzer, DTS, SQL profiler

Confidential

SQL Server Developer

Responsibilities:

• Created Database tables with constraints and relationships between multiple tables.
• Created Views, User Defined Functions and Triggers.
• Extensively used the VB coding and HTML usage. Developed user Interface screens using Visual Basic 6.0
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Documented requirements to be used in the development process of a data warehouse (extensive use of UML).
• Experience in defining database architecture, database testing.
• Analyze and Evaluate Existing Architecture and Design and Configure a complex Network architectures onAWSCloud.
• Used AJAX function calls using JQuery functions to handle the user requests asynchronously and to have faster responses from the server by directly connecting to the server.
• Implemented web services, used to retrieve data that tells whether claimant is incarcerated or not.
• Developed applications using Hibernate persistent framework, developed persistent classes, hibernate-mapping files, configured XML files, hibernate query language.
• Developed JSP pages for correspondence team.
• Implemented web services using WSDL/SOAP and created web services and clients to use those services.
• Designing a Back-up solution and a Disaster Recovery inAWS.
• Server migration from physical datacenter toAWScloud.
• ImplementAWSTrusted Advisor to provision resources and improve performance, reliability and security issues.
• Created Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.
• Automated testing the user interface screens using SQA.
• Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability.
• Used LINQ to query against strongly typed collections of object and various data source, XML documents, Web services, ADO.Net Objects and Entity Framework 4.0.
• TSQL database querrying, triggers, stored procedures, views.
• Administering SAP Products.
• Worked with Logical and physical models inErwin(ETL). Expertise in forward and reverse engineering usingErwin(ETL).
• Performed various data transfers between various servers using BCP and DTS. Supported team in resolving in DTS and T-SQL related issues.
• Involved in performance tuning and query optimization.
• Converted logical Database Design into Physical schema using the balanced normalization in 2nd and 3rd Normal form for highest performance.
• Improved the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Transferred data from flat files, Excel spreadsheets to and from SQL Server using DTS, BCP and Bulk Insert.
• Regularly monitor the system for bottlenecks (CPU, RAM, Disk IO).

Environment: SQL Server 2005/2008, Oracle 8i, T-SQL, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0, Microsoft Reporting Services 2.0.

Confidential

SQL Server Developer

Responsibilities:

• Created Database tables with constraints and relationships between multiple tables.
• Created Views, User Defined Functions and Triggers.
• Extensively used the VB coding and HTML usage. Developed user Interface screens using Visual Basic 6.0.
• Reduced monthly Infrastructure running cost by subscribing Reserved instances for always runningAWSservers.
• Responsible for development of Business logic in CoreJava.
• Implemented Spring MVC to achieve Model View Controller design pattern. Configured spring to manage actions as beans and set their dependencies in a spring context file and integrated middle tire with spring web layer.
• Developed test classes in JUnit for implementing unit testing.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Extracted data from different data sources; aggregated and implemented various calculation measures to create financial data analysis
• Administering SAP Products.
• Dimensional and Relational databsae modelling.(Logical and Physical)
• Created Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.
• Scheduling the DBCC commands to run daily, weekly basis. Developed automated tasks for daily, weekly and monthly database maintenance such as database backup, database integrity verification.
• Expert in using DMV’ Confidential, Performance dash board, Mirroring, database snapshot.
• Worked file and file group Backup/Restore. Maintained the database consistency with DBCC at regular intervals
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in Retirement/Pension relatyed development scheme projects.
• Involved in logical designing and physical designing the databases using Erwin.