Nasir Majeed
Sr Data Base Administrator @The National Institutes of Health
Signup · Get unlimited contacts
WORK HISTORY
Sr Data Base Administrator @The National Institutes of Health
Bethesda, MD, US
Lead SQL Server DBA for more than 120 SQL Servers including mission-critical applications and servers• Migrated SQL Server from 2008 to 2012 to 2016 Version • Installed and configure SQL 2017 on Linux Red hat 7 • Migrated data from DB2, MySQL and Oracle to SQL server 2014 using SSIS packages.• Installed and configured and maintain multi-subnet AlwaysOn using SQL 2014 and SQL 2016 on VM.• Configure and manage Disaster recovery using SQL Server log shipping, SQL Server Always-On Availability Groups. • Daily administration, space management, optimizing queries including data warehousing extracts.• Set up, administer, master/incremental backup and performance tune MS SQL Server database instances in a Microsoft Azure Cloud (MAC) environment for proof of concept (POC) to support testing of migrating existing MS SQL Server database instances to cloud and evaluated, reviewed and proposed plans to migrate current Information system into cloud (AWS) to support future 24/7 real-time applications.• Worked to configured AWS RDS and Windows Azure SQL Databases for cloud application database.• Installed and configured MapReduce, HIVE, Pig and the HDFS; implemented Hadoop cluster on AWS/ubuntu using Cloudera Manager. Assisted with data load from SQL Server to HDFS with SQOOP.• Performs database backups and recoveries including disaster recovery planning using Log Shipping and Replications.• Developed and/or maintained a security scheme for the database environment. Ensures continued security and integrity of databases.• Maintained data warehouse server for Logins transactions using SSIS package to upload daily data. System was migrated to SQL 2008 to utilize partitioned tables and indexes feature.• Conducted ongoing assessment of database performance, resource requirements, and the identification of problem areas using Diagnostics Manager.• Maintained and published all data-related standards, policies and procedures.
EDUCATION
University of the Punjab
BSC, Math
SKILLS
ABOUT NASIR MAJEED
Proven DBA skills and information technology consulting experience. 15+ years of database administration, data warehouse, replication, enterprise storage and system development experience using XML, SQL, PL/SQL, UNIX, Window shell scripts, and.NET.Specialties: Microsoft Certified Database Administrator (MCDBA)Microsoft Certified Solution Developer (MCSD) for.NetOracle Certified Professional (OCP –8i)
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.