SUMMARY:

Versatile IT professional with strong SQL Server background, 5+ years of experience administering, designing, implementing, automating and managing databases. Extensive hands - on experience in installations, configurations, security, deployment, backups, performance tuning, upgrades, and patches on different platforms. Solid professional knowledge on Microservices, Software Processes, Dependability/Non-Functional Requirements, Network and Distributed Systems and Configuration Management.

SKILL:

• SQL Server, SQL Server Polybase, MySQL, Azure Data Studio, Tivoli Storage Manager
• Windows, Mac, & Linux
• SQL Server Big Data Clusters, Kubernetes, Docker Containers, VMs, Python, Nagios
• Hadoop (HDFS), SQL on Hadoop Technologies (Impala, HIVE, Spark), AWS

EXPERIENCE:

Confidential, MD

Sr. Programmer Analyst

Responsibilities:

• Continuous work for use cases and benchmarking petabytes of astronomical data for the Large Synoptic Survey Telescope project using technologies like Hadoop/HDFS cluster, Kubernetes, Docker containers, and Parquet.
• Design, install, monitor, maintain, and performance-tune production and research databases containing the largest scientific datasets while ensuring high levels of data availability.
• Troubleshoot and proactively monitor systems and applications to identify and correct malfunctions and other operational difficulties.
• Support and maintain recovery systems and operations, including but not limited to maintaining backup system configuration, performing SQL Server backups on windows and Linux machines to Tape, monitoring backups, and performing restores as needed of databases over 100TB.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Install and configure relevant components to ensure database access as well as database security, consistency and integrity.
• Respond to and resolve database access, security and performance issues.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. Successfully implement HA cluster on transactional databases.
• Plan and coordinate data migrations between systems.
• Help scientists design and implement efficient software applications for database access.
• Establish appropriate end-user database access control levels and implement changes be adhering to change management policies.
• Set SQL Server and TEMPDB configuration that best meets the user needs depending on the usage of the database (read-only, transaction, size).
• Backup and restore of MySQL databases on Linux machines to network location using Cron jobs.

Confidential, MD

Database Administrator

Responsibilities:

• Evolved a service over time from past efforts using Django and Python to develop a tool that allowed researchers to publish data, research papers and search through data published by others in the field.
• Provided a repository using Globus for data management that expedited research administration, project collaboration, and community interaction.
• Gained experience with version control, change management and unit testing through the development of the data sharing service called CRAEDL.
• Conducted numerous interviews overtime with potential users including Principal Investigators, Post Docs, and other research scientists to examine the needs, experience, and usability of the product being developed.
• Researched and tested with multiple technologies such as WordPress, Drupal, and Django to create a document and data sharing infrastructure for researchers to store and share their data with others.
• Designed and developed the schema and sharing functionality for immediate in-house researchers: A web interface that offered a project repository with metadata and direct links to access datasets and code of researchers.
• Created a FileMaker database with provided schema for administrative staff at Confidential .
• Altered schema and created reports to meet administrative needs.
• Created a database management system to store and publish researcher’s publications to track and count for evaluation annually.
• Trained and provided guidance to staff members in proper database access and use.

Confidential, New Jersey

Systems Administrator

Responsibilities:

• Manage SQL Server acting as EMR application backend database server. Create new databases, users, custom applications, T-SQL scripts, and SSIS packages. Push application changes and upgrades with schema and code. Write PowerShell Scripts to enhance productivity. Monitor performance, server disk-space, logs, etc. Perform analysis and tuning to ensure data pushes from staging to production. Protect data with regular backups and regulate testing to meet RPOs and RTOs.
• Supported and maintained Windows Servers 2003/2008/2012, VMware, Citrix servers hosting Electronic Medical Record (EMR) application (SaaS model) through the use of CMC as well as Terminal Services.
• Daily responsibilities include system tuning, specification, configuration, maintenance, capacity planning, and account access control of workstations and laptops of all end-users.
• Network troubleshooting to isolate and diagnose common network problems, virus, or system failure.
• Developed new security policies and implemented email encryption solution throughout the environment under HIPAA compliance. Improved system security daily by managing FortiGate firewall system with the use of custom web & spam filtering.
• Evaluated, redesigned, and improved existing IT infrastructure by introducing new Servers, Hardware, Software, and Monitoring Systems. Built and migrated several servers such as Active Directory, DNS, SQL Server, File Server, Backup server, and print server.
• Re-configured existing back up and restoration process to construct better disaster recovery procedures (in coordination with IT Director) and business-continuity plan.