| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLE Cell: PHONE NUMBER AVAILABLE Chantilly, VA Street Address
SUMMARYAs a SQL Server Database Administrator with 5 years of experience, I am proficient in cloud technologies, encryption, database management, migration, and high availability solutions. I have successfully migrated databases to the cloud, implemented encryption, and maintained high availability solutions such as Always On Availability Groups and Failover Clustering. I have strong communication skills and have experience working collaboratively with cross-functional teams to achieve project goals. Overall, I am a highly skilled and experienced SQL Server Database Administrator who is committed to delivering high-quality solutions that meet the needs of the organization.Experience Highlights: With 5 years of experience as a SQL Server Database Administrator, I possess extensive expertise in AWS and Azure DB Instance creation, migration, management, maintenance, and monitoring. I have experience in designing and implementing high availability (HA) solutions such as database mirroring, log shipping, clustering, and always-on availability groups (AAG). Additionally, I am proficient in designing and implementing backup and disaster recovery (DR) strategies. I have extensive experience in database security administration, including user security and role management, and have implemented Transparent Data Encryption (TDE) to secure sensitive data. I have cloud experience and have successfully migrated databases to the cloud, implementing HA and DR strategies. I possess excellent analytical and problem-solving skills, and am highly effective at communication and customer service. Lastly, I have in-depth knowledge of database indexing and query optimization, and have optimized database performance for large-scale environments. Experience:JTP Inc., Lincoln, NJ SQL Server Database Administrator 11/2019 - PresentAs a SQL Server Database Administrator at JPT Inc., I am responsible for managing and maintaining the SQL Server instances in AWS and Azure environments, as well as ensuring their high availability through technologies such as Windows Server Failover Cluster (WFSC) and Always On High Availability groups. In addition, I work closely with customers, managers, and team members to ensure positive communication and cooperation and to continuously improve the customer experience. This involves configuring and managing individual user environments by installing and configuring SQL Server, Microsoft Visual Studio, and SharePoint.As part of my role, I am also responsible for migrating databases from Oracle to SQL Server and updating and upgrading SQL Server and SharePoint as needed. I create stored procedures, triggers, functions, views, tables, and run updates as requested, while efficiently managing SQL and SSIS package jobs and monitoring and modifying them as needed.Moreover, I am responsible for managing SharePoint content and site collection databases, creating site collections, and maintaining backup and restore plans or scripts. I create jobs using PowerShell and batch files for scheduling jobs to run by using Windows task scheduler. Additionally, I create databases, new tables, Candidate's Name
Email: EMAIL AVAILABLE Cell: 703 447-3285 Chantilly, VA 20151 columns, and test data integrity, set identity, set constraints, modify the design, create an index, update index, defragFEI Systems, Columbia, MD SQL Server Database Administrator 12/2016 - 10/2019 Provide support for SQL Server multiple servers for various customers/agencies. Troubleshoot and resolve day-to-day database systems issues like connectivity problems, user permissions, unlock user accounts, deploy code on databases in different environments. Create new databases as requested as part of managing the database. Develop and maintain Extract, Transformation and Loading (ETL) mappings to extract the data from multiple source systems like Oracle, SQL Server, and Flat files and loaded them into Oracle. Responsible for the implementation and release of database changes, track change management, and report development as production support. Responsible for database installations and configurations on Relational Database Management Systems(RDMS). Resolve complex database problems, implementing schema changes. Work with the development team on the promotion of new development efforts to the production systems. Install and configure new instances online and integrate them into the current environment. Technicourse, Fort Lauderdale, FL SQL Server Database Administrator 03/2015 - 11/2016 Managed SQL Server databases, including installations, configurations, updates, and upgrades. Designed and developed new database systems and maintained existing systems. Developed, implemented, and maintained backup and recovery plans for all databases. Created and maintained database objects, including tables, views, indexes, and stored procedures. Performed performance monitoring and tuning to optimize database performance. Education:Bachelors degree, Tribhuvan University, NepalCertification/Training: Completion Certificate in SQL Server Database Administration (DBA) Training Completion in SQL Server Reporting Services Training Completion in SQL Server Integration Services Training Completion in Amazon Web Services Training Completion in Microsoft AzureCandidate's Name
Email: EMAIL AVAILABLE Cell: PHONE NUMBER AVAILABLE Chantilly, VA 20151 TECHNICAL SKILLS:SQL Server Tools:ETL/Reporting:Design/DataModel/Case Tools:Backup Tools:Platforms:Network:HA & DR:Security:Third Party Tools:Documentation &Ticketing:SSMS, Query, Microsoft Visual Studio, BIDS, T-SQL, Perfmon, PowerShell, SQL Server Tuning Advisor, Extended Event, Audit, Database Engine Tuning Advisor, Activity Monitor, Query Execution Plan, Query tuning and performance monitoring.SSRS, Power BI, SSIS, Report BuilderErwin, Visio, Database DesignVERITAS, Netbackup, SQL Native BackupWindows, Windows Server, VMware, MS Azure, AWS, Hyper-V on Premise and on Cloud (AWS/Azure)TCP/IP, DHCP, Static & Dynamic ports, DNS, UDP Telnet, endpoint Mirroring, Logshipping, Replication, Windows Server Failover Clustering, Always On High Availability, Coop operation.Apply updates, patches, configure TDE, Encryption in transit, Data Masking, and create Audit, Alert, and notification.Spotlight for SQL Server, Idera, SQL Diagnostic Manager, Red Gates/Tools Belt for SQL monitoring, and Toad for SQL.Service Now, Service Manager, JIRA, and Confluence. |
