SQL Server DBA /Azure DBA

• May 2014 - Present

 Worked with Jira ticketing system software to solve issues as and when the ticket comes in the Queue.  Installation, Administration and Maintenance of SQL Server Instances.  Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)  Create Users and assign permissions based on the level of database access the user would need. (Security)  Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration) Show less

DBA

• 2013 - 2014

DBA

• Mar 2013 - May 2013

Sr.SQL Server DBA

• Jan 2012 - Mar 2013

Highly skilled software professional MS SQL Server 2012/2008 R2 /2005 database development and administration in enterprise production environment Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc.  Developed database applications Programming Using T-SQL in MS SQL (stored procedures, triggers, data integrity constraints, etc.), Design and develop logical and physical database models for new/re-factored applications and processes.  Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.  Work with DBA in performance testing and tuning custom applications. Participate in the design and development of data marts to support analytical reporting requirements.  Create and maintain technical and operations documentation and assist in the creation of work estimates and project plans.  Work closely with DBA and IS management to develop and implement policies and procedures for software development and maintenance.  Evaluate and implement new tools and technologies for database development  Provide reports that measure the quality and quantity of work performed.  Provide input to manager that will help streamline and improve consistency in service levels.  Responsible for assisting with hardware sizing and procurement, installations and upgrades.  Business knowledge of Healthcare Systems and Claims Management.  Excellent skills using Microsoft Reporting Services, Crystal Reports, SSIS, SSRS, SSAS, SQL table partitioning. Show less

Sr.SQL Server DBA

• Jun 2011 - Jan 2012

Project Description The Disability Insurance Automation (DIA) solution is the implementation of a secure electronic communications and information processing environment that promotes efficiency and reduces costs while following Health Insurance Portability and Accountability Act (HIPAA) regulations and guidelines. HIPAA provides the Employment Development Department (EDD) an opportunity to realize the advantages of electronic communications with claimants, medical providers, and employers. The project seeks to significantly improve on its delivery of Disability Insurance services by focusing on the three primary business goals, allowing EDD to: Improve access to Disability Insurance services Improve EDD's service delivery Detect and prevent fraud and abuse Perform day to day Database Maintenance tasks -- Clustered & Non-clustered Database Monitoring, Backups, Space Management, Resource Utilization, responsible for performing object migration between all production database Servers. Manage hierarchical security (access control, permissions, encryption keys and certificates) for databases and ensure data integrity using templates and schemas. Ability to prepare for and participate in security audits and database encryption, and disaster recovery measures. Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on the server. Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues. Proven experience in maintenance of SQL Server in a VLDB environment & experience in troubleshooting and resolving database problems. Strong experience with SQL Server performance tuning and optimization, query optimization, index tuning, caching and buffer tuning, using sp_Indexoptions & DBCC Showcontig, etc. Show less

Sr.SQL Server Database Architect/DBA

• Jun 2010 - Jun 2011

Worked as a Sr. Support Lead at Microsoft Corporation in Redmond, Providing 24/7 support in Sql Server for Microsoft which provides support for operational deployment and support for a variety of internal corporate tools and external facing localization tools throughout Microsoft. Support teams in India, Redmond, Dublin and East Asia, The objective of this project is to support Incident, change the release management in the production system and mission critical Microsoft internal application. Each SQL Servers contains databases from 10 to 100 depending upon the size of the database which rages from 100MB to 2TB. All servers are High End and contain Multiprocessors of 4 to 32 and RAM (Random Access Memory) from 1GB to 8GB depending upon the load. The support includes administration and maintenance of the databases which include multi-tasking activities such as checking the server health, job schedules, blockers, alerts, replication, log-shipping, deadlocks, and disk space managements, archival and purging.Responsible for maintaining the highest levels of systems availability, data delivery and availability, and customer satisfaction for all assigned systems Resolved Issues which are identified by the SCOM Alerts which will be generated messages in our email. Implementing and administering database replication between SQL Server databases as well as dissimilar databases. Troubleshoot database performance issues and tune database objects. Set up traces and Profiler to troubleshoot performance issues. Analyze deadlocks & diagnose issues on the server Writing code and creating jobs to automate repetitive tasks. Troubleshoot Infrastructure issues related to SQL database server such as memory, CPU, I/O, Disk, etc. Monitor log files to proactively resolve issues.Handling backup process, writing the automated jobs for taking the weekly full backup, daily differential backups and hourly transactional backups.Regular SQL Server Maintenance Activities Show less

Database Architect/DBA

• Dec 2009 - Jun 2010

Support production business applications by assisting in ad-hoc database analysis and troubleshooting. Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, DTS, backup/restore, database corruption, security, programming etc. Working at an escalation level (Secondary Response Group, SRG) and working with issues which are very time consuming and complex. Developed database applications Programming Using T-SQl in MS SQL (stored procedures, triggers, data integrity constraints, etc.) Design and develop logical and physical database models for new/re-factored applications and processes. Design, plan and implementation of VMware infrastructure and specific network for virtualization. Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status. Work with DBA in performance testing and tuning custom applications. Participate in the design and development of data marts to support analytical reporting requirements. Create and maintain technical and operations documentation and assist in the creation of work estimates and project plans. Work closely with DBA and IS management to develop and implement policies and procedures for software development and maintenance. Evaluate and implement new tools and technologies for database development Meet service level agreements for all client escalated issues. Provide reports that measure the quality and quantity of work performed. Worked with data management and data processing flowcharting techniques Provide input to manager that will help streamline and improve consistency in service levels. Work with the Project teams for the assigned applications during the in-cycle (bug fixes) and the out-of-cycle (new releases) application changes. Represent Support requirements as per the SDLC process. Show less

Database Architect/DBA

• Jan 2009 - Dec 2009

Installation, configuration of MS SQL Server 2000, 2005, 2008 for development and testing purpose. Migration of SQL server 2000 to SQL server 2005 and monitoring and solving the issues after migration. Setup, configure and monitoring Transaction Replication, snapshot Replication on remote servers. Created and monitored database maintenance plans for checking database integrity Creating databases, logins and Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server's logins (Windows and SQL Accounts). Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications. Created DTS packages to export and import data from SQL SERVER to Access, text and EXCEL files. Responsible for database backups & restoration and scheduling backup strategies. Implemented Disaster Recovery Plan using Log shipping, Mirroring and Replication. Running DBCC consistency checks, and fixing data corruption in user databases. Planning, implementing and troubleshooting Snapshot and Transaction Replication. Prepared Estimates for Database, table size growth. Worked with SQL Server Reporting Services (SSRS), implemented report builder to allow customers build their report. Generated reports using SQL server report manager and published as PDF formats. Created report models for Report Builder and managed reports using Report manager. Migrated report system from a custom Crystal Reports system to SQL server 2005 Report Services. Responsible to bring the awareness of the importance and techniques involved in DB tuning and Performance, to the developers. Implemented Transactional Replication for Real time Reports (Database Server as Publisher and Reporting Server as Subscriber). Show less

Sr.SQL Server Database Architect/DBA

• May 2008 - May 2009

Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements. Performed acceptance testing to verify that database changes perform without adverse consequences. Estimated disk storage requirements for database software, database files & database administration needs. Involved in loading the partner flat files into the OLTP database. Also, developed the T-SQL stored procedures/functions to process these data and populate them in the appropriate destination tables. Created and configured an OLTP replication database for disaster recovery purpose. Worked with developers to tune the SQL queries using SQL Profiler. Worked with Star Schema, Cubes and Analytical services. Provided 7 x 24 Production support for the database and application issues. SSIS Jobs, Reporting Jobs through SQLCMD, Archiving, Gather Database counters Status report of all the jobs, Database consistency checks, Data Refresh, Data Masking. On call support. Created and maintained the knowledge base system for all the application databases Provided guidance to the development team on writing stored procedures and implemented the standards, guidelines and best practices for database development Show less

Team Lead & Sr.SQL Server Database Architect/DBA

• Jul 2006 - May 2008

Managed the products and development databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity Supported all production operation activities, with focus on integration and development of new and existing products and services this includes managing indexes, performance monitoring, backup recovery procedures and designing, testing and publishing a disaster recovery plan. Usage of derived tables, table variables, complex queries and joins, sub queries, transactions, user defined functions, views, exporting using SSIS, automating jobs to import data from and to flat files. Up gradation of Database from SQL Server 2000 to 2005 and 2008. Installed & configured database software, associated database tools and performance monitoring software. Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements. Performed acceptance testing to verify that database changes perform without adverse consequences. Estimated disk storage requirements for database software, database files & database administration needs.Provided optimal database file layout for utilization of storage and performance acceptable to client. Participated in meetings impacting databases physical design. Customized support for Client's Applications (e.g. Third party supported/In-House Applications etc.) provided client will won the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.). Provided appropriate access to client except system databases owners' and Client will have access to their respective needed application schema owners. Developed & maintained scripts, utility jobs or implement needed software for database maintenance.Implemented & managed database clustering, failover and load balance technologies as per client requirement. Show less

Sr. Database Architect/DBA

• Sep 2005 - Jun 2006

Responsible for database security and performance, coordinates physical changes to SQL Server databases Supported all production operation activities, with focus on integration and development of new and existing products and services Familiar common database monitoring and analysis tools(SCOM,MOM,Safemon) Provides database system administration, including: backup, disaster recovery, tuning, security planning, etc. Monitors database performance and modifies database programs to increase processing performance, referred to as performance tuning Responsible for activities involved in the analysis, design, development, troubleshooting, debugging and maintenance of enterprise transactional systems. Plan, design, and implement application database code objects, such as stored procedures and views. Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. Perform quality assurance and testing of SQL server environment. Show less

Team Lead Database Architect/DBA

• Sep 2004 - Aug 2005

Team Size :5 Created logical and physical database design modeled to support the displaying of realty based information through use of online tools such as customized search engines for retailers, property pages, and virtual agent support. Monitoring all the 40 production databases and fixing the production issues. Managed 40+ SQL Servers, from 20 gb servers to a 2 terabyte Tuning the database servers, when the user reports that a particular region is running slow. Creating and refreshing Databases on development environment, making it sync with production when new development activity starts. Creating new schemas and modifying the existing schemas based on the changes for the new development activity. Performance tuning on stored procedures, queries to support the application to run faster. Created and monitored the jobs to perform tasks such as database cleaning, backups, data loading. Performed Migration of Databases from one physical server to another when the size of the database increased and business needs changed. Responsible of capacity management with a strong ability to anticipate future demands and growth by working closely with key stakeholders. Strong documentation skills in documenting processes, procedures and tools descriptions. Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically and vendors Participate in and contribute to Release activities including Spec reviews Show less

Database Architect/DBA

• Jun 2004 - Sep 2004

Domain Banking System Team Size :10 Involved in performance tuning, code optimization, development using Visual Basic 6.0, ASP and COM+ Conducted System Analysis, Design, Development and Implementation of various Applications and the subsequent transition to ERP and Web Enabled Application. Experience of Application Code Review. Performed all the Database related activities such as Database Backup, Restore Operations, Troubleshooting Issues as and when occurs, Performance Tuning, monitoring error logs, jobs etc. Involved in Logical Data and Index Partitioning using SQL Server 2005. Designed, implemented & maintained DTS Packages Handled data Migration from legacy systems as well other RDBMS such as Sybase and FoxPro. Involved in Fine Tuning the Procedures After studying the Processing time through SQL Trace. Modified & created Indexes, Optimizing Indexes. Migrated data from various sources such as MS Access, flat files etc. Show less

Senior Database Administrator

• Jan 2003 - Jul 2004

Team Size :3 Developed & executed scripted changes requests in accordance with change control procedures. Provided overall configuration and change control management for data base components. Escalated database issues to appropriate approvers (if applicable). Set up security and access profiles and procedures for database system administrators. Complied with standard security-related procedures that are based on established best practices and conformity to company policy and adjusted to accommodate Client Security Policy based on mutual agreement. Interfaced with database vendors & client technical support teams to isolate & resolve database related problems. Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster up to 8 Node. Handled Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008. Provided & managed support to Environment of more than 500 Database Servers. Proven ability to handle Database of more than 1 TB in Size. Expertise in MSSQL SERVER Database Administration. Set up Log Shipping, MSSQL Mail, SMTP Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Env.) for various groups such as Developer, QA, DA, User etc and ensured the Availability of the Database Server in a 24X7 Environment. Scanned the data pages, Indexes and checked the storage space used by each table. Suggested, developed & implemented Scaling out solution with Data partitioning. Managed security by defining roles and rights. Handled Fine Tuning Operating System in-coordination with Server and Network Administrator to utilize the maximum resources for Database and Applications. Monitored the database server performance and if required go for tuning of the TSQL queries, Stored procedures etc. Show less

Database Architect/DBA & Team Lead

• Jan 1998 - Nov 2003

Up gradation of Database from SQL Server 2000 to 2005 and 2008. Installed & configured database software, associated database tools and performance monitoring software. Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements. Performed acceptance testing to verify that database changes perform without adverse consequences. Estimated disk storage requirements for database software, database files & database administration needs. Provided optimal database file layout for utilization of storage and performance acceptable to client. Participated in meetings impacting databases physical design. Customized support for Client's Applications (e.g. Third party supported/In-House Applications etc.) provided client will won the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.). Provided appropriate access to client except system databases owners' and Client will have access to their respective needed application schema owners. Developed & maintained scripts, utility jobs or implement needed software for database maintenance. Implemented & managed database clustering, failover and load balance technologies as per client requirement. Developed, tested & implemented a robust database backup and recovery strategy with client assistance. Requested refreshes pre or post restore activities (e.g. data loads). Database recoveries as per requirements. Conducted root cause and analysis for database incidents and problems. Participated in designing, testing and implementing an enterprise Disaster Recovery Plan. Monitored data activities (i.e. database status, logs, space utilization, extents, Checkpoints, locks and long transactions). Show less

Team Member

• Jan 1997 - Sep 1998

Environment: Visual Basic 5.0 / MS SQL Server / RDO / Crystal Reports/Oracle Description:Super Market Maintenance System - This application is developed for a super market to maintain its inventory, sales and customer follow-ups. The system stores details about items that are categorized under different groups. Sale, purchase, receipts, payment etc is also maintained by the system. It prompts the user to place order when an item reaches its reorder level. It advises the user not to place order for an item that has reached its maximum stock level. It maintains details about regular and Bulk Customers and their credit limit. Periodical sales report, stock report, customer follow-up report etc can be generated. Responsibilities included: Meeting the customer to analyze the requirements. Provide inputs to the documentation team Designing the database Designing the user interface for Master and transaction entry screens Developing Master and transaction entry screens with business logic Developed database applications Programming Using T-SQl in MS SQL (stored procedures, triggers, data integrity constraints, etc.) and ActiveX controls (ocx files) Implement the product in the client's site and Training the users to use the product. Show less

Software Analyst

• Dec 1995 - Nov 1996

Environment: Oracle 7.0 and Forms 2.5 Description:Payroll Management System The application starts off from formation of a Company. Then it inputs the Employee related information and in which group company/department he is recruited. Just assign the employee a salary structure and you are ready to generate and manage payroll processes with respect to that employee. Also the end user has the flexibility to create his own salary structures and salary formulae. The pay slip is generated after the attendance is marked for that month. ESIC and PF challans are available at the convenience of a mouse click. The payroll software also manages the Company Holidays and the Bank holidays. Responsibilities included: Designing the database Designing the user interface for Master and transaction entry screens Developing Master and transaction entry screens with business logic Implement the product Training the users to use the product. Show less