SUMMARY

• 10 years of experience as an MS - SQL database Analyst from Confidential .
• Provide technical leadership for the architecture, design and operational support of the Bank’s Database Systems and its associated technologies to meet requirements of High Availability, consistent performance, scalability,and security.
• Lead and participate in initiatives with the Business, Applications and Technology Infrastructure teams to design and deploy Database environments hosting core in-house transactional payment processing and 3rd party vendor systems.
• Continuously assess and identify inefficiencies and gaps in current Database technology portfolio and recommend solutions.
• Lead the evaluation and recommendation on emerging technologies in support of increasing cost effectiveness and systems flexibility to meet business needs.
• Design, plan and lead the implementations of solutions using Database technologies and its functional capabilities based on business requirements while effectively integrating into existing Database Infrastructure, smoothly transition knowledge of the solutions to the members of Database Services team for deployment and operation.
• Establish and support the enforcement of technology standards, processes and policies related to Database Services functional area.
• Develop database architectural strategies at the modelling, design and implementation stages to address business and industry requirements.
• Provide technology mentorship and support for escalated incidents and problems to Database Services team members.
• Assist with the development, documentation, communication and enforcement of policies for standardizing Database software configurations and usage as necessary.
• Plan, design, and analyze the agency’s Database and Storage infrastructure according to best practices, while ensuring high levels of data quality and availability;
• Integral in the development, implementation of policies and procedures to ensure consistent storage provisioning, uptime, and regulatory compliance;
• Ensure the integrity and availability of databases and their accompanying software;
• Overall capacity planning, backup and restore process design, performance analysis, and developing data disaster recovery plans;
• Develop and establish technical and operations, installation, preventative maintenance and overall system performance standards;
• Provide architectural expertise, direction, and assistance to database administrators and Engineering teams;
• Design, architect, Install and configure relevant network components to ensure Enterprise database infrastructure as well as database consistency and integrity;
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts;
• Establish appropriate end-user database access control levels;
• Design redundant systems and policies for disaster recovery and archiving to ensure effective protection and integrity of storage appliances and stored data assets.
• Interact with agencies and internal department heads to determine needs to fulfill executive management project plans/priorities;
• Maintain current knowledge of storage-related laws, trends, and issues, including current and emerging technologies and best practices. Develop strategies and policies to ensure best-practice based regulatory compliance and reduce the enterprise’s legal exposure.
• Perform capacity planning analysis and other needs assessments to inform storage architecture strategy.
• Project management/project lifecycle experience.
• Perform special projects and initiatives as assigned.
• Excellent knowledge on database transaction, performance tuning and security audits;
• Excellent knowledge of SAN, clustering, encryption, content - addressable storage, technologies from Netapp and Pure solutions.
• In-depth knowledge Multiple Database architectures (Oracle, MS SQL).
• Advanced skill, documentation and overall windows 2008/2012/2016 OS.
• Advanced skill, documentation and multiple in RHEL OS versions.
• Experience working with Multiple Storage Solutions, Netapp.
• Knowledge of Cloud solutions (AWS and MS Azure).
• Excellent written and verbal communication skills.
• Excellent analytic, organization, presentation, customer service and facilitation skills.
• Excellent problem-solving skills.
• Ability to handle multiple tasks under tight deadlines.
• 18 years of Experience as an SQL Database Architect in MSSQL 7.0, 2000, 2005,2008, 2008R2,2012,2014,2016,2017, ORACLE, SYBASE and Postgres.
• Hands on experience with SQL 2016 on LINUX
• Thorough understanding and hands on Experience of Azure Cloud Database-as-A-Service, Managed Instances, Infrastructure as a Service, VM on Public Cloud and Private Cloud.
• Hands on experience on Postgres database server.
• Master in MSSQL/Windows Project management, SQL licensing, Replication, Always On Windows/SQL Cluster, Always On AG, database mirroring, log shipping etc.
• SQL license - Recommended what types of SQL license needed for different servers (SERVER + CALS), saved license cost for businesses.
• Thorough understanding of Microsoft Azure public cloud and Bank’s Private Cloud.
• SQL solution provider by understanding requirement of the applications and projects.
• Master of Database Security Designing as per the requirement of the application.
• Thorough knowledge of Bank’s Database Security Standards and best practices.
• Extensive experience with Database mirroring, Always ON Cluster and Availability Group technology.
• Worked with ORACLE, SYBASE, MSSQL, Postgres & Informix database servers.
• Working experience with RCM (Production Change Release) process.
• Working experience with accounts enrollment on Fire Call (CPA)
• Hands on experience on SQL auditing, application auditing by working directly with KPMG and Confidential ’s internal Audit department.
• Master of monitoring system like SCOM.
• Through knowledge of SCCM.

PROFESSIONAL EXPERIENCE

Confidential

Senior Database Administrator

Responsibilities:

• Expertise in MS SQL Server (2000,2005,2008,2008R2,2012,2014 and 2016) database administration in enterprise production environment including SQL Server installation, configuration, upgrade, maintenance, high availability/disaster recovery solution setup, performance tuning, query optimization, backup/restore, recovery, migration, monitoring, security planning and trouble-shooting.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions including Mirroring, VERITAS cluster, Microsoft SQL Server cluster and Always on availability groups.
• Good Experience with MSSQL services (SSRS/SSAS/SSIS/Full text/Polybase/R) and OLAP.
• Proficient with SQL Server Management Studio, SQL Enterprise Manager, Query Analyzer, Business Intelligence development studio, rescheduling jobs with SQL Server Agent, SQL Profiler, DMV’s, restoring database using full, differential, and log backups.
• Good experience with Microsoft Windows server 2012/2008R2/2008.
• Very proficient with Windows 2012/2008/10/8/7 client & Server operating systems.
• Experience of working on OS policy settings related to SQL Server.
• Experience in suggesting database design changes to vendor for enhanced performance.
• Extensive experience with Storage Capacity Planning, including system storage allocation, on-going capacity analysis and planning future storage requirements.
• Experience with use of RAID, SAN technologies.
• Experience of dealing with SQL licensing (core based or server CAL).
• Good Experience with MSSQL services (SSRS/SSAS/SSIS/Full text/Polybase/R) and OLAP.
• SQL Server Upgrade from lower version to upper version and migration of databases.
• Good knowledge of Transparent Data Encryption (TDE).
• Change Management Requests handling, Code Reviews.
• Patching SQL Server.
• DB Refresh.
• Resolving blockings and Deadlock Issues.
• Database consistency checks and troubleshooting issues.
• Provided 24x7 on-call Support.
• Review SQL problems and recommend service improvements plans.
• Attending meetings with the client/business with crisp and clear communication.
• Reviewing/preparing functional specifications, documentation, preparation of KB articles, best practices, process/Project improvement plans.
• Experience on production support and mission critical application.
• Good experience in troubleshooting critical issues using various Dynamic management views (DMVs).
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tunes the same to improve performance.
• Very good experience in MSSQL Server patching and troubleshooting issues related to Patching.
• Knowledge of implementation of software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs.
• Applying patches and service packs to keep the database at current patch level.
• Working with tools such as DB Artisan, Ignite, Red Gate products to compare data and DB objects.
• Administration, maintenance and implementation of policies and procedures for ensuring security, integrity of the complex databases and compliance with audits.
• Good understanding of VB, C#, Power shell, Azure Cloud and AWS.
• Knowledge of enterprise backup and restore system (NetBackup).
• Proficient in working with technical and functional Team. Good experience of working with Microsoft Engineers to resolve critical issues.
• Well adhered to ITIL processes like change control, problem management.
• Adhered to security compliance like SOX compliance.
• Building SQL Server Infrastructure for multiple projects simultaneously (both standalone and clustered environments) and facilitating project team with any issues related to database security, SQL Server performance and database migration.
• Setting up high availability solution for SQL Server Environment (Always on Availability Groups, SQL Server Cluster and Replication).
• Implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• SQL Server Database Administration, System Analysis, Design, Development & Support of MSSQL Servers 2016,2014, 2012, 2008 R2, 2008, 2005 and 2000, Mirroring, Clustering and Reporting Services in Production, UAT, Development and IST environments.
• Participated in Solution Design meeting with Solution Architects as SQL Subject Matter Expert to provide work effort estimate and database consulting.
• Upgrading SQL Server from version 2005 to 2008 R2/2012/2014
• Creating maintenance plans to perform backup, re-indexing and update statistics.
• Capacity planning.
• Ensure compliance with all technical specifications.
• Installation/Configuration/Management of MS-SQL.
• Maintenance plan creation, Monitoring backups and maintenance jobs.
• Creating Databases, Tables and Database snapshots.
• Deploying the codes for every release.
• Creating stored procedures, functions.
• Checking database integrity using DBCC commands.
• Resolving blocking issues.

Confidential

LAN Administrator

Responsibilities:

• Configuring NTFS security for domain users at Windows server level.
• Applying domain policies to new domain users.
• Creating mail accounts for Confidential users.
• Creating application accounts for application users.