SUMMARY

• Senior Database Analyst with 11+ years of experience in Designing and Maintenance of data and database solutions, Performance Tuning & System Optimization, Database Health, Security & Recovery (HA & DR), Data Analysis, Problem Analysis, Automation and Scripting.
• Devised Maintenance & Evaluation of database performance by measuring metrics from Database System to fix and optimize.
• Highly skilled in n - tier architecture data solutions, resource scaling (On-premises and Azure Infrastructure), Service Health & Efficiency, System Telemetry.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Analyzing exceptions to identify root cause on data quality issues raised and liaison with Operations, Business and Data Scientists to route the issue appropriately.
• Significant knowledge and experience in data modeling and understanding of different data structures and their benefits and limitations in practical applications.
• Expert in understanding and deploying Database Best Practices/Methodologies, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques.
• Well-versed with DevOps, Supply chain management, Agile, Scrum & ITIL Project models. Extensive background in Service Engineering & Operations, Release Engineering, Production Support, Application Programming.
• Proactively analyze business information needs and functional requirements, identify business problems and propose strategies to ensure automation and timely delivery in a clustered environment systems.
• System Auditing and data modifications/amendments in systems using SQL Server tools and coding techniques. Plan and coordinate security measures alongside Server and Network administrators.
• 15% increase in business by expanding the applied solutions and methodologies in different port-folios.
• Designed & Developed service telemetry creating a huge difference positively to monitor and analyze the trending of service.
• 40% improvement in transaction processing through the optimization techniques.
• In-depth analysis of Disk I/O, Memory & CPU through Counters & DMV’s.
• Deploying effective error handling techniques.
• Identifying scope of improvement in terms of Incremental/Full data load that fits appropriately for the business requirement
• Improving READS & WRITES through filtered, covering Indexes and column store indexes.
• Data & Page compression techniques
• Index tuning & Data partitioning
• Fine tuning of Complex queries
• 25 out of 50 datasets are permanently out of SLA breach (50% Improvement)While the 40% improvement in transaction processing has impacted the SLA's, the remaining 10% does required the right engagement & Co-ordination with Business, Engineering & Operations.
• 30% of OLAP processing performance by demonstrating the impact
• Index tuning
• Identifying costly queries to tune & implant bad Joins & Selects
• Cube partitions & Effective application of Aggregations
• Tuning/Remapping the attribute relationships.
• Service Automation (Ex: PowerShell Scripting & C#)
• Have automated the most repetitive database and server administration tasks for the effective and productive time utilization.
• 30% improvement both in Time & Performance compared to Original

TECHNICAL SKILLS

• SQL Azure, SQL Server (2012, 2014 & 2016 Versions), MSBI Stack and TSQL programming. Data Engineering and Analysis, Telemetry, Problem Analysis, Bug Fix and Feature deployments, Power-shell scripting, Automation and Power BI Reporting. GTM, Hadoop,
• Tools & Technologies worked: Azure Technologies, Azure Operations Manager suite, Azure Application insights, IIS (7.0) administration, Microsoft Precise, GTM Load balancing, AppFabric caching, NetScaler Load balancing, Content Switching & Akamai, Biztalk Server 2006, My SQL, Gentran Server and a basic knowledge in share point.,
• Coding & Scripting: C#.Net and Open source technologies,
• Operating Systems: Windows Azure, Windows 2014, Windows 2012, Windows 2008 R2, Windows server 2000, 2003Windows 8 & Linux,
• Web Related/Open Source Technologies: PHP, HTML, Java Script and CSS, MySQL Development and Administration,
• Microsoft Tools & Utilities: Visual Studio.Net, Microsoft SCOM, Windows TFS (Bug tracking and Source Safe Server) and Eclipse.Domain Knowledge, eCommerce, Integration services, Finance, Supply chain management and Change release management.

PROFESSIONAL EXPERIENCE

Senior Database Analyst,

Confidential, Redmond, WA,

Responsibilities:

• Conduct root cause analysis and resolve production problems and data issues.
• Created and implemented database design solutions in collaboration with programming team.
• Created and scheduled SQL server automated jobs in a timely manner of daily, weekly and monthly processes.
• Creation of SQL Logins, groups, roles and authentication modes as a part of Security Policies for various categories of user.
• Analyzed application database performance and made ongoing adjustments to ensure optimal performance.
• Configure & Maintain Always On, Mirroring, log shipping, Replication management, Linked Servers and Security.
• Assist with the design of redundant systems, policies, and procedures for disaster recovery to ensure effective availability, protection, and integrity of data assets.
• Automated numerous functions and maintenance activities.
• Backup and recovery of production, development and test databases.
• Applied service packs, patches and hot fixes in production and QA environments.
• Disk capacity planning, performance monitoring, and fragmentation management.
• Installation and configuration of OS & SQL Server in different versions.

Database Analyst,

Confidential, Redmond, WA,

Responsibilities:

• Experience with rebuilding the indexes and statistics update at regular intervals for better performance.
• Expertise in designing databases and capacity planning.
• Followed best practices to ensure application database security including regular reviews and adjustments to access levels by authorized users and applications
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented. Applied procedures for regular database backup including method and backup frequency
• Document service tier related duties/activites as required.
• Ensure and maintain a highly available and secure database environment
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Senior Database Administrator

Confidential, Redmond, WA,

Responsibilities:

• Handling Memory configurations on different versions of SQL Server & Windows OS.
• Hardware performance and capacity planning.
• Hardware troubleshooting (high disk loading, queues, wait state analysis, resolving memory resource issues, CPU performance issues) in virtual and physical environments.
• Implemented and Scheduled Replication process for updating our parallel servers in autonomous sites.
• Database configuration & deployment with respect to the organization access methods and documentation.
• Deployed procedures to ensure database tuning, capacity, and future capacity planning

Server Tools Online,

Confidential,Redmond, WA,

Responsibilities:

• Knowledge of database performance factors, monitoring tools and tuning procedures.
• Install, configure and maintain SQL Server database products
• Involved in Analyzing and Upgrading to OnPremise & Azure from lower versions of SQL Server
• Lead efforts to develop and improve procedures for database performance monitoring and proactive intervention.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Maintain database replication and automation tools, patches for bug and security vulnerabilities, Security of the application servers and databases

Production Support DBA

Confidential,

Responsibilities:

• Partitioned large and problematic active tables in OLTP & OLAP environment, and performed query tuning and stored procedure diagnostics.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Performance tuning and VM configuration standards.
• Oversee technical support of all database technologies including monitoring, reporting, patching, troubleshooting and code deployment
• Optimized MS SQL Server code in production SQL databases.
• Monitored and modified Performance using execution plans and Index tuning.
• Monitoring and tuning OS and server configurations.
• Monitoring SQL Server Logs to ensure the backup operations, batch commands, or other scripts and processes have completed successfully.