SUMMARY

• Microsoft Certified SQL Database Administrator with over 8 years of hands on experience in Database Administration and Development for very large and complex databases in SQL Server 2016, 2014, 2012, 2008 R2, databases.
• An enthusiastic individual with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources.
• Trained in AWS Cloud Administration.
• Assist organizations with identifying use - cases for adoption of Amazon Web Services and best practice implementations.
• Planning and implementing High Availability (HA) and Disaster Recovery (DR) Architectures including Clustering, Log Shipping, Merge Replication, Host Based Replication and various I/O subsystems including SAN. Database object creation and modifications, backup/recovery, security administration, troubleshooting, performance monitoring and tuning, capacity planning, product evaluation, consultation with developers on technical issues, database design, and systems analysis.
• Extensive experience in Database Design including data requirements, data classification, and logical and physical data modeling. Design specifics included creating/maintaining Entity Relationship Diagrams (ERD), data dictionaries, and physical data structures. Extensive experience in constructing triggers, tables, user functions, views, indexes. Extensive experience with monitoring, tuning and analyzing DB performance and allocating server resources to achieve optimum performance.
• Systems Analyst experience: project plans, creation of standards, policies, procedures, requirements definition, extensive security analysis, functional analysis, data exchange frequency. Recommended mission critical software. Provided assistance to developers through supervision and SQL review, tuning, and directing and analyzing stress test cycles.
• Support for private, public, hybrid or multi-cloud environments, working with different cloud platforms (OpenStack, Kubernetes, VMware) and with different public clouds (GCP, AWS, Azure). Integrating third-party software and hardware into the system

TECHNICAL SKILLS

Database: SQL Server 2017,2016, 2014, 2012, 2008r2, 2008, 2005, MS Access, PostgreSQL, PgAdmin

Languages: SQL, T-SQL, XML, ASP, ASP.net, HTML, JavaScript

BI/ETL/Tools: SSIS, DTS, SSRS, Report Builder, Cristal Report

Third Party Tools: ERWin, OpNet, RedGate, SQL Sentry, DBArtisan,Toad Data Modeler, Pentaho data modeler

Networking: Active Directory, DNS, TCP/IP, LAN, HTTP, Linux

Hardware/Storage: SAN, RAID, ISCSI, Microsoft Azure, AWS

Native tools: SSMS, Performance Monitor, Query Analyzer, Extended Events, SQL Profiler, Execution Plan, Activity Monitor, DBCC, DMV, BIDS/DTS, Job Activity Monitor, Query Analyzer, Database Tuning Advisor, Built-in-Standard Reports.

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential, Washington D.C

Responsibilities:

• Ensure the performance and scalability of SQL Server 2008,2012,2016 and PostgreSQL databases
• Implement, refine and maintain database replication and failover
• Install, tune and monitor PostgresSQL Database Instances
• Develop, refine and monitor recurring database jobs/scripts
• Participate in database design for new features/functionality
• SQL and PL/PGSQL coding utilizing Pentaho data modeling tool, and PGadmin
• Query analysis and optimization
• Created data modeling with Tableau, Geographic information system (GIS)
• Creating and organizing geodatabases in Tableau connecting to Oracle RDS and PostgreSQL database management systems.
• Data import, data migration, data conversion, Georeferencing, general map creation of various data from different sources.
• Updated and standardized GID database for the Confidential project
• Processed high-resolution imagery for analysis and basemaps, created maps for various productions databases to ensure the accuracy of data being imported in Tableau and Pentaho tools.
• Designed multiple-software suite workflows for data manipulation
• Researched most efficient implementations of topology and algorithms
• Work with developers to review schemas and SQL changes to application software and make recommendations when needed
• Create SQL scripts for individual databases as needed
• Administering large PostgreSQL databases ability to do performance tuning/index maintenance experience of backing up and restoring, PostgreSQL databases on regular basis and data validation.
• Designing and managing PostgreSQL database schemas
• Knowledge of fault detection and resolution processes
• Designing and managing PostgreSQL database schemas, security access control with testing and configuration management knowledge with version control
• Responsible for configuring, integrating, and maintaining, development, staging production databases

Database Developer/ Data Architect

Confidential, Washington, DC

Responsibilities:

• Administer MS SQL Server 2008,2012, 2017,2016 in both Clustered and Non-Clustered Development, Test and Production environment and provide information and solutions for various groups such as Developer, QA, DA, Client, Users. Monitor Server and database performance using SQL Server native tool such as PerfMon, Profiler, DTA, Activity Monitor, DBCC, Execution Plan, DMV, Extended Events
• Extensive knowledge and experience in T-SQL to create and manage database objects such as Keys, Constraints, Trigger, Synonyms, Functions, Stored-Procedures, temp table, table variable, CTE etc. Work on Schema and comparison using Visual Studio/Native SQL queries. Knowledge and experience on Powershell Scripting
• Create and implement backup strategy, Configure and maintain HA/DR solutions such as logshipping, mirroring, Clustering, AlwaysOn and replication (snapshot and transactional)
• Troubleshooting server/database slowness and query optimization when required. Use DBCC and DMV to check database conditions, fix database corruption, rebuild indexes and current activities of the server. Maintain and Troubleshoot day to day database security, created custom database and application roles as required, SQL Security including windows AD groups, Kerberos, and LDAP calls
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support, data warehouse star Scheme
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products
• Implement and manage scheduled jobs to collect different activities such as database health, file growth, disk space, locking, blocking and deadlocking, Agent Job Failure, unexpected growth of TempDB and Transaction Log. Applying SP, Hot Fixes and CU on cluster, standalone and mirror environment. Implement table partitioning for large table to address space issues and performance.
• Plan and maintain step by step documentation, upgraded SQL Server 2000/2005/2008 R2 to 2008R 2/ 2012/2014/2016 and migrated data from MS Access/Oracle databases into MS SQL Server 2008R2/2012
• Work on data modeling projects from end to end including generating scripts for objects, and Creating E-R Diagrams
• Install, configure and administer SQL Server Reporting Services (SSRS). Develop and deploy DBA reports and client reports (drill down, matrix, parameter report)
• Upgrade SSIS package from older version to newer version. Load, transport and move data from flat file, Excel, Oracle, MySQL, MS Access, OLEDB Data Sources to SQL Server and vice versa using export/import, BCP and SSIS. Experience in Job creation, scheduling and troubleshooting job failure. Create proxy account and execute SSIS package for Proxy use

Environment: Windows Server 2012 R2, 2008 R2, IIS 7.5, SQL Server 2017, 2016, 2014, 2012, 2008 R2, ASP, ASP.net, PHP, AD (Active Directory)

Database Administrator

Confidential, Washington, DC

Responsibilities:

• Designed database and implemented multiple systems using MS SQL Server. Responsible for MS SQL Server configuration, tuning and providing 24x7 dedicated support to all Production, development and clustered servers
• Expertise in Always-On Availability Groups (AAG) and HA/DR Setup and Configuration
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Used Dynamic Management Views performance dashboard, Mirroring, database snapshots & tracking Performance Counters
• Recovered databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Expert in implementing the snapshot isolation and DDL triggers.
• Rebuilt/monitored the indexes at regular intervals for better performance.
• Performed index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases
• Implemented data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression (CTE)
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers)

Environment: Windows Server 2012 R2, 2008 R2, IIS 7.5, SQL Server 2012, 2008 R2, ASP, ASP.net, PHP, AD (Active Directory)