| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Street Address
EMAIL AVAILABLEPHONE NUMBER AVAILABLESummary8+ years DBA experience and in-depth knowledge of Microsoft SQL Server 2008/2012/2016 and utilitiesProficiency in relational database management System (RDBMS) in MSSQL server 2008, 2008R2, 2012, 2014 and 2016.Experience in installation of MSSQL Server and configuring backups, DB Mail, and user permissions.Experience in configuring and troubleshooting Oracle 19c and MySQL database servers.Experience in setting up SQL Server cluster and Log shipping.Experience in implementing Secure Sockets Layer (SSL) Certificate for SQL Server Cluster and Standalone.Experience in setting up Transparent Data Encryption (TDE).Experience in setting up Column level Encryption.Experience in creating and maintaining database objects, functions, triggers, stored procedures in MSSQL and MySQL servers.Experience on patching, upgrading and Migrating SQL Server Software to new versions.Experience in capacity planning, implementing and SQL Database migration.Experience in setting up Management Data Warehouse (MDW) to collect data about the server.Experience setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.Experience with SSIS, creating and deploying SSIS packages/projects.Excellent knowledge and Experience in backup/restore operations, database design, T-SQL (DDL, DML and DCL).Hands on Experience on Security management in MSSQL, Oracle 19c, & MySQL: System and object privileges, creating and modifying roles.Knowledge in database technologies (MS SQL Server Cluster design, Always On Availability Group, Replication).Proficiency in varies server operating system and applications, installation, configuration and troubleshooting.Ability to learn quickly retains knowledge, apply effective interpersonal skills, and perform effectively under time pressure.Excellent listening and communication skills.EducationMasters in Information Systems Management (Database Administration) (6/2014)KELLER GRADUATE SCHOOL OF MANAGEMENT, NEW YORK, NYBachelors of Science in Biology (6/2012)COLLEGE OF STATEN ISLAND, STATEN ISLAND, NYClearanceActive Secret clearanceCertificationsMTA: 98-364 - Database Administration FundamentalsTechnical SkillsOperating Systems: Microsoft Windows 7,8,10, Ubuntu and Centos.Software: MS SQL server 2008, 20008R2,2012, 2014, MySQL 5.1 5.6, SSMS, SSIS, SSRS, Oracle 19c, MySQL Workbench, Microsoft Office Word, Excel, Outlook, PowerPoint, Access, Project, Visio, Enterprise MacAfee, VMware VCenter, Apache Hadoop, Hive, Pig, Flume and Sqoop.Database Migration: SQL Server to SQL Server, MySQL Server to MySQL ServerETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)Data Modeling Tools: Visio, SSDD (SQL Server Database Diagram), Oracle data modeller.Languages: Linux commands, HDFS shell commands, T-SQL, PowerShell scripting.Employment HistoryASRC Federal Holdings (NASA Ames Research Center), San Jose, CADatabase Administrator April 2017 presentResponsibilities:Install, Configure, and Maintain Databases in (MS SQL server 2008, 20008R2,2012, 2014,2016), Oracle 19c and MySQL 5.0/5.1/5.5Perform Database Backup/Dumps, Database Restore on MSSQL, Oracle 19c and MySQL servers.Monitor Server Activity, Error Log, space usage and solving problem as neededMonitor, troubleshoot, resolve and report on data integrity problems in Databases, nightly backups, SQL jobs, and log shipping.Setup Maintenance plans for backups, Rebuilding or reorganizing indexes, check server health, alert, notificationsPerform Oracle 19c database refresh using expdp/impdp data pumpSetup SQL Server Agent Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processesImplementation of Permission, Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.Maintained server and database security including database encryption (TDE).Implement SSL certificate for SQL server Cluster and Standalone.Maintain databases and database instances currently hosted at Amazon AWS services on EC2 instances.Copy files from AWS EC2 instances to S3 bucket.Write SQL/T-SQL queries, Stored-Procedures, Views, functions, and TriggersDevelop and maintain database structures, database objects, and ETL processes.Create and implement SSIS package for the automation of ETL process.Responsible for setting up SQL Server jobs to monitor disk space, CPU activity and Index fragmentation.Monitor automated jobs using UNIX based scripts (e.g. shell) for data processing and data backups.Work closely with QA and Development Teams in reporting and fixing database related bugs in software.Assist our development team with writing effective T-SQL stored procedures and views.Experience in administering Linux based systems.Provide technical support and guidance to resolve issues with exceptional customer service.Apply critical thinking to complex problems where analysis of situations and data requires an evaluation of numerous factors and collaboration with more senior DBAsAnalyzes and diagnoses problems reported to the Database queue in help desk ticketing system.Celerant Technology corpSoftware support Technician, April 2015 April 2017Responsibilities:Provide technical support and guidance to resolve issues with exceptional customer serviceInvestigate, Troubleshoot and resolve all POS software, Database and Application server related problemsWork closely with QA and Development Teams in fixing reported Software BugsManage and Maintain Database (MS SQL server 2005, 2008, 20008R2,2012, 2014) and Application serverManage and maintain scheduled SQL Server Agent jobs in Production Database server and Data warehouse DatabaseUse SQL to create reports and manipulate data.Resolve communication problem among POS Frontend, Application server and DatabaseTroubleshoot Application Port problemsPerform Database Backup, Database Restore if necessaryProvide and control Database access permissions and privileges to usersConfigure and install POS software based on clients requirementTroubleshoot and solve data integrity problems in DatabaseCreate Reports based on Client's requirementProvide assistance with recovery of lost or corrupted dataProvide on call support remotely |
