Description
PROFESSIONAL SUMMARY * 16 years of experience in Microsoft SQL Server Database Administration on SQL Version 6.5, 7, 2000,2005,2008, 2008R2, 2012, 2014 and 2016, SQL Azure * Experienced in full life cycle of database administration in SQL Server. Worked both as a Production Support/Infrastructure DBA. * Monitoring the mental and physiological status of staff and take appropriate action to mitigate stress and complete the projects within stipulated timeframe. * Document the architecture for database upgrade/migrate from one RDBMS and/or platforms to another. * System and Database performance management and monitoring so as to abide by the SLAs. * Managing Active Directory with reference to security credentials, Group Policy and server management. * Executing the test scenarios/UAT (User Acceptance Testing) for the databases based applications and hoisting of Websites using IIS. * Maintaining the SQL Server health, backups and restoration of databases in the order of few TBs. * Managing and optimizing database, creating jobs and schedules so as to avoid dead-locks. * Maintain database and application roles security by monitoring/granting and revoking privileges to vendors/users on the Production server. * Working with Change Management/Release Control Team in the release of patches and or fix in sequential manner against MS SharePoint Environment and/or SQL Server by creating CAB tickets and tools like Visual QSM. All developed objects are propagated to production by me after CAB/Helpmanster Change Management approval. * All Production Servers and Development/Staging Servers databases are backed up using a third party tool "Redgate Toolbelt" and monitored using third party tools like SQL Sentry. * Gathering and documenting business requirements to support key enterprise projects and project team members and Identifying and promoting process improvement opportunities for gathering requirements * Create and maintain Project Charter and Customer Requirement Template for each assigned project * Scope and Assess each project impact from each grouping and perform risk analysis with Subject Matter Experts * Update existing and or develop new Use cases based on Project Impact * Create process flow diagrams and sync up those diagrams with IT team for accuracy and maintain them for future reference * Prepare Business Process solution and to drive high level Impact summary to the Business and system used * Perform Gap analysis between current system and future system to make sure all the data elements need to perform and the business has been taken care of * Conduct JAD (Joint Application Design/Development) sessions with business and or IT to support all key projects that have already been funded * Facilitating review of completed business requirements with project stakeholders, business functional and IT partners in order to secure buy in sign off requirement deliverables * Supporting the development of functional requirement and system design to ensure that they meet defined business and project objectives * Make sure all the independencies are meet during detail requirement and sync up the requirement with internal Domain partners * Maintaining the Business Requirement Traceability document in JIRA/Wiki/SharePoints. * Support change control of documents during and/or after the project being implemented * Supporting the development of functional requirements and system design to ensure that the requirements met defined business and project objectives. * Make sure all Internal management reporting as well as external client facing requirements are met during detail requirement and validating that reporting requirement will meet the business needs * Expertise in developing database architecture and coding standards from need assessment to QA/QC, design & support * Experienced in Microsoft SQL Server Upgrade. Installation, Configuration, Performance Tuning and Administration) * Currently updating knowledge on Cloud computing solutions, SQL Azure in MS SQL 2014 DBA, etc. * Skilled in conducting DB/SQL performance tuning with tools and techniques like SQL Profiler, Perfmon Optimizer Statistics, Partitions, Indexes and MS Baseline Security/SQLIO advisors. * Experienced in pre-upgrade tasks considering SQL Server 2012 minimum hardware and software requirements. Create and maintain an inventory of the applications that access the server, database-collation requirements, server dependencies, and legacy-systems requirements such as data-access methods. The list includes database consistency checks and backup of all databases. Setting plans in place for testing the upgrade process and applications which involves thorough understanding of backward-compatibility issues and identify workarounds or fixes. The process includes using the SQL Server 2012 Upgrade Advisor, to assist in identifying and resolving these issues. * Experienced in running the upgrade execution process which is a smooth execution of your well-documented and rehearsed plan. To reiterate the importance of this step, ensure you make a backup of all the databases before you execute the upgrade process. * Experience in running Post-upgrade tasks consisting of reviewing the upgrade process, bringing the systems back online, monitoring, and testing the system which includes performing specific database maintenance before releasing the system to the user community. These and other recommended steps are executed based upon the system responses. Identifying the database collation and running the database in backward-compatibility mode after the upgrade to minimize the amount of change to your environment. Updating the database-compatibility mode as part of a follow-up upgrade process and enable new SQL Server 2012 features. * Resourceful in reviewing and improving checklists for activities like upgrades, migrations, backup & recovery, etc. within established Service Level Agreements (SLAs) * Possess in-depth knowledge of ITIL Processes & Tools * Worked on large Database System running into multi-Terabytes (TBs) troubleshooting DB connectivity & availability issues * Preparing documentation, including recording the procedures, standards, guidelines, and data descriptions necessary * Strong problem solving & technical skills coupled with confident decision making for enabling effective solutions leading to high customer satisfaction and low operational cost
Accomplishments
Highlights:
Keywords
