SUMMARY

• SQL Server Database Administrator with 6+ years of hands - on professional experience specializing in administering SQL Server Databases (on-premises and cloud environments).
• Experience in migrating databases from on premises data center to AWS cloud
• Experience in managing AWS RDS databases for SQL Server, MySQL, PostgreSQL and Oracle
• Working experience in configuring and administering High Availability Databases like Database Mirroring, Replication, Log shipping, Clustering, Always On Availability Group, Backup/Restore
• Experience in Performance Tuning by using SQL Server Native Tools (Execution Plan, Profiler, and Database Tuning Advisor, Extended Event) and Windows Performance Monitor
• Experience in implementation of safeguarding sensitive information using encryption for data at rest - SQL Server TDE and encryption in transit SSL encryption, AWS RDS database encryption using AWS KMS
• Upgrading databases and applying Service Packs (SP) and hot fixes\CU for SQL Server databases
• Profound experience in creating and supporting database administration scripts & scheduling jobs
• Good customer support experience in providing end-user support on a day-to-day basis
• Working in Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC and OLE DB drivers
• Experience in creating and scheduling SSIS/DTS packages for Extract Transform and Load - ETL
• Installing and maintaining SQL Server Reporting Services. Skill in building and deploying complex reports including matrixes, charts, gauges, and KPIS in SSRS and Power BI
• Experience in Managing File Maker Server and FileMaker Pro Databases
• Experience in Managing SAP Crystal Reports and Business objects using SAP Central Management Console (CMC) to publish reports and manage user security

TECHNICAL SKILLS

Database Engines: SQL Server, MySQL, Oracle, PostgreSQL, FileMaker Server (FMS),FileMaker Pro/Advanced, MS Access

Cloud Services: SQL Server on AWS EC2; AWS RDS databases for SQL Server, MySQL, PostgreSQL and Oracle; SQL Server on Azure VM; SQL Azure; DynamoDB; Redshift; Athena

Database Tools: SSMS/SQL Server Management Studio, PG-Admin, MySQL WorkBench, Oracle SQL Developer, Enterprise Manager, Query Analyzer, SQL Profiler, Database Tuning Advisor and Index Tuning Wizard, BCP, SQLCMD, Upgrade Advisor

Data Migration Tools: SQL Server Migration Assistant/SSMA, Data Migration Assistant (DMA), Azure Database Migration Service (DMS), AWS Database Migration Services (DMS), AWS Schema Conversion Tool (SCT)

Business Intelligence/ETL Tools: SQL Server Reporting Services (SSRS), Reporting Services Configuration and Report Builder, Power BI, Crystal Reports, SAP Business Objects, SQL Server Integration Services (SSIS), IBM Cognos, Tableau

Data Modeling: Toad Data Modeler, ERWin, SSDD (SQL Server Database Diagram)

Programming: SQL, T-SQL, PL/SQL, HTML, C++, Java, PowerShell, Python

Operating System: Windows Server 2012, 2008/R2, 2003/R2, 2000, VMware, Hyper-V, LINUX/UNIX

Storage: SAN, RAID, EBS, EFS, S3

Monitoring Tools: Profiler, Execution Plan, PerfMon, Database Tuning Advisor (DTA), DMV, Activity Monitor, FogLight, SpotLight, SiteScope, Nagios, Cloud Watch, New Relic, Solar Wind

PROFESSIONAL EXPERIENCE

Confidential, New Brunswick, NJ

Database Administrator

Responsibilities:

• Assisted in migration of SQL Server and Oracle databases from on premises data center to cloud environment (AWS RDS)
• Performed database upgrade of SQL Server and Oracle RDS database instances
• Installed and configured SQL Server database systems on-premises data center and on Amazon EC2 instances ensuring successful backups, resolving system issues, monitoring failure of automated jobs, monitoring system availability and database recovery in the Cloud.
• Build SQL Server database servers using AWS Amazon Machine Images (AMI): Creating volumes, launching EC2, creating security groups in the defined virtual private connection
• Setup and maintenance of appropriate database and application monitoring and database health checks using custom SQL Scripts and third-party monitoring tools such as Solar Winds
• Setting up Database \Availability Groups and Replication on Staging and Production servers
• Worked in Active-Active, Active-Passive Cluster environment as a high availability solution
• Tuning queries which are running slow using Profiler and DMV by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications
• Responsible in managing File Maker Server and FileMaker Pro Databases
• Responsible in installing, configuring, creating, and publishing Crystal Reports
• Experience in Managing SAP Business Objects using SAP Central Management Console (CMC) to publish reports and manage user security
• Project planning, designing, and executing SQL Server 2008R2 and 2012 database upgrades to SQL Server 2014, 2016 and 2017 environments
• Setup SQL Server instances in AWS EC2 virtual machines and on Amazon’s RDS environment
• Migrated SQL Server 2016 databases from on-premises data center to AWS cloud
• Provide escalation support for troubleshooting and resolving database\application issues as well as perform a root cause analysis
• Design and Develop SSRS reports (SQL Server Reporting Services) to replace manual report processing for different divisions
• Created SSRS report to convert Crystal Reports and migrate away from SAP Business Objects reporting
• Design and developed large ETL processes for extracting data from a central data warehouse
• Encrypt sensitive data using SQL Server TDE and implement SSL encryption for data in transit
• Provide On-Call support for mission critical applications

Confidential, Herndon, VA

Database Administrator

Responsibilities:

• Installing, configuring and maintaining MS SQL Servers.
• Setup Database Maintenance Plans to reorganize indexes, rebuild indexes and update index statistics on the production databases.
• Fixing missing indexes and Excess indexes.
• Transparent Data Encryption (TDE) understands data corruption and troubleshooting encryption problems.
• Prepared Documentation for the Disaster Recovery plan, database maintenance procedures, data standards, procedures and definitions for the data dictionary.
• Writing Stored Procedures, Triggers and Functions as per client requirements.
• Creating and Deploying SSIS Package and SSRS Report.
• Data Warehousing, Table Partitioning and Indexing Strategies.
• Analyze long running slow queries and tune them to optimize application and system performance.
• Maintaining data integrity and ensuring database security through access controls and best practices.
• Perform daily check ups on SQL jobs, replication, and hardware diagnostics for hard drives, backups, and windows error logs as part of proactive maintenance plan.
• Upgrading databases with new releases and patches.
• Performing Data Extraction, Transformation and Loading (ETL) into a central repository.
• Managing Production, Stage, QA and Development database environments.
• Run DBCC commands to check the database consistency and shrink the databases.
• Resolving various performance issues and running DBCC commands, SQL Tracer, SQL Server Profiler.
• Monitored and modified performance using execution plans and index tuning.