Ms Sql Dba Consultant Resume
Tampa, FL
SUMMARY
- Over 6 years of experience in the administration of UNIX, Red Hat Linux, RHEL, Sun Solaris, AIX, HP UX, VMware on various Hardware Platforms.
- Extensive Experience in Installation and Administration of RHEL 3.x/4.x/5.x/6.x, Red Hat Linux8/9, Sun Solaris 8,9,10, AIX 4.3/5.1/5.2/5.3/6.1/7.1, Windows Server 2003/2008
- Creating and maintaining user accounts, profiles, security, permissions, disk space and process monitoring
- Job scheduling using Cron
- Configured services like DNS, NIS, NFS, LDAP, Send Mail, on Red Hat Linux and AIX.
- Responsible for setting up disaster recovery environment on Red Hat Linux servers, Solaris Severs and various applications and implemented all the DR procedures as per the guidelines.
- Networking communication skills and protocols such as TCP/IP, Telnet, FTP, SSH, DHCP.
- Installation, Configurations and administrations of Issue Tracking application Atlassian - JIRA.
- Installation, Configurations and administrations of Wiki application Atlassian-Confluence.
- Installation, configuration and implementationof webserver Apache Tomcat.
- Experienced with installation of packages, patches, maintenance &RPM updates on Red Hat Linux.
- Experience with adding and implementing SSL certificates (CA vendor) and troubleshooting and updating SSL versions.
- Proficient with various stages of deployment like Submission, Prep, Audit, PkgArchieve, Integration, Build, Staging, Prod etc.
- Experience in LDAP, configuration, user management & group management.
- Trobleshooted build errors by checking Makefiles, package.spec files, pkginfo, post-install scripts etc and orchestrated deployment scripts.
- Worked with VMware ESX 3.5/4.0/5.0 servers, and Virtual Infrastructure client to create virtual guests.
- Ensured system security by hardening and auditing the systems as per guidelines in IBM AIX and Red Hat Linux also experienced in system analysis, troubleshooting and performance tuning of operating systems.
- Scripting done in Korn, Perl, Bash, CSH,Bourne shell and for automating tasks.
- Perl & Python scripting for application use.
- Extensive use of VI editor for day-to-day system admin work.
- Possess strong analytical and troubleshooting capabilities, proactive listener and team player with positive approach and excellent grasping power.
- Experience in ENV file creation for development teams, as per OS value (ia32/ia64 RHEL, Solaris, Win,AIX)
- Assisted developersbuild deployments (Native Windows Software - Microsoft Installer (MSI), Java client software - Java Network Launching Protocol (JNLP via CDDT or GFI Toolbar), Windows Server: Microsoft Installer (MSI),Red Hat Linux (Intel): Red-Hat Package Manager (RPM),IBM AIX: Backup File Format (BFF)),IBM z/Linux: Red-Hat Package Manager (RPM),Sun/Solaris: System V Packaging (SysV, pkgadd, or Dstream)
- Extensive knowledge on AtlassianProductsJIRA, Confluence. (Agile-SCRUM, Kanban, Bamboo, Fisheye, Greenhopperconfigurations)
- Extensive knowledge on Source Version control systems (SVN, CVS, PVCS, GIT).
- 24X7Monitoring and providing resolution to incidents occurring on UNIX and Windows Servers, plus various applications.
- Identifying, correcting and reporting processing slowdowns, malfunctions and abnormalities.
- Performing root cause analysis and event correlation, problems related to the services, or at the request of the client; identifying preventive measures; and making recommendations to fix root causes.
- Experience with OSI model and all it layers.
- Experience with PCCMcompliance and processes involved making changes in various environment.
- Experience in Planning & performing Major BAU activities working with application team, System Admins, DBA administrators, engineering & development team.
- Experience in leading/working with a team, onsite-offshore models and independent environment. Very good coordinating experience with program managers, testing teams, database administrators and end users.
TECHNICAL SUMMARY
Operating Systems: Linux (RHEL 3.x/4.x/5.x/6.x, Red Hat 8/9/, SUSE 10 &Debian), Sun Solaris 8,9,10, HP UX, IBM AIX 4.3.3/5.1/5.2/5.3/6.1/7.1
Web Servers: Apache Tomcat 6.0 & 7.0, Weblogic 10,11g
Network Services: SMTP, SNMP, DHCP, POP,, NFS, DNS, FTP/TFTP, SSH, TCP/IP, NTP, TELNET.
Programming languages: C, C++, java, JavaScript, HTML programming, RDBMS, SQL/PLSQL,Python,Perl
Monitoring tools: BMC (Patrol), Alarmpoint, Sitescope, Autosys, Tivoli
Scripting: Bash, korn, KSH, CSH, Perl Scripting, Shell Scripting
Issue Tracking tool: Atlassian-JIRA (Agile-Scrum/Kanban), Fisheye,Greenhopper
Source Control: SVN (Solaris/Linux/AIX & Tortoise), CVS,PVCS, GIT
Ticketing Tools: Servicenow, ResolveIT, Taskman, RFC, Marketplace etc
Databases: Oracle 11g, MSSQL Server 2003,2008
PROFESSIONAL EXPERIENCE
Confidential, Tampa, FL
MS SQL DBA ConsultantResponsibilities:
- Administered, maintained Red Hat Enterprise Linux 4.X/ 5.X troubleshooting hardware, operating system, applications & network problems and performance issues.
- Installed and Configured RHEL 4.X/5.x Servers/Workstations.
- Implemented and Enhanced the existing scripts which are developed in Bash.
- Involved in applying new patches and packages for Linux Servers and handled issues arising out of them.
- Responsible for deploying various types of application packages including JAR, WAR and EAR files.
- Implemented and configured ACL, for client product associated with cost structure.
- Experience in Shell scripting (ksh, bash) to automate system administration jobs.
- Scheduling the jobs using CRON tab.
- Installed various packages and assisted developers to create there packages for build deployments (Native Windows Software - Microsoft Installer (MSI), Java client software - Java Network Launching Protocol (JNLP via CDDT or GFI Toolbar), Windows Server: Microsoft Installer (MSI),Red Hat Linux (Intel): Red-Hat Package Manager (RPM),IBM AIX: Backup File Format (BFF)),IBM z/Linux: Red-Hat Package Manager (RPM),Sun/Solaris: System V Packaging (SysV, pkgadd, or Dstream)
- Providing post deployment support for upgrades/changes/enhancements done on production (Live) Environment.
- Involved in troubleshooting with various stages of deployment like Submission, Prep, Audit, PkgArchieve, Integration, Build, Staging, Prodetc
- Trobleshooted build errors by checking Makefiles, package.spec files, pkginfo, post-install scriptsetc and orchestrated deployment scripts.
- Experience with applications and Build Portals hosted on Weblogic server.
- Scripts written in Perl shell for daily monitoring of servers regarding the number of hits, database connections and middle tier connections.
- Mounting and Setting up NAS volumes for various repos.
- Setting upmonitoring tools such as BMC (Patrol), Alarmpoint, Sitescope, Autosys, Tivoli forvarious applications in different domains.
- Setting up and configuring LDAP for sso authentication for various application.
- Added SSL certificates and updated versions when required. Troubleshooted errors related to SSLin running applications.
- Installing various Products/Packages/Vendor Softwares in cross-environment, and configuring their compatibility and syncing on various servers.
- Created ENV file developers for domain creations, depending upon environment(32-bit 0r 64-bit), operating system (OS value), and product deployment (example java, oracle,weblogic,tibcoetc).
- Troubleshooting issues related to compilers, C, C++, Pcreate, Ant etc
- Performed COB (Disaster recovery) on yearly basis for various application servers.
- In regards to SVN, we createrepositories,perform administrative taskson the repositories.
- Scripting (Shell Scripting/Perl/Python) related to creating hooks, configurations,notificationsetc.in SVN repos.
- Creating SVN UI environment for user management in Python.
- CreatingPyhton/Perl scripts for product install, retirement, update etc on Unix environment.
- Integrating SVN with JIRA, confluence, eclipse etc.
- Performing Migrations for SVN repos from one version to upgraded version, from one project to other, from one server to otherserver, from one source control (PVCS/CVS) to SVNetc.on UNIX(Solaris/Linux) environment retaining versioning history(revisions history).
- Backing up Source Code lost accidently via revision history.
- Dump creation, dump filter and dump backup activities for SVN.
- Creating JIRA projects, managing access, creating custom fields, schemes, screens, workflows etc.
- Creating SCRUM, Kanban boards on JIRA agile, configuring and implementing plugins etc.
- Green hopper, Fisheye configuration in JIRA&Confluence.
- Installing and configuring Apache Tomcat for JIRA application.
- Troubleshooting JVM issues in JIRA and Confluence application.
- Troubleshooting issues on PROD, UAT and DEV/Test environmentsand various Databases.
- Familiar with Apache maven, Maven product installation, nexus repository etc.
- Assisting development teams to troubleshoot any application or infrastructure issues, supporting deployment related issues, in Integration, UAT/PROD environment.
- Coordinatingwith different teams like Application Team, DBA Team, Vendor support for the root cause analysis of various issues.
- Configured various services, devices as well as applications of UNIX servers and worked with application team to customize the environment.
- Managed Physical and Logical volumes, Volume Groups in Linux.
- Extensive working experience in process scheduling, disk and file system I/O, kernel internals, TCP/IP networking.
- Implementing Changes to the Production/COB and UAT environments through Change Control Procedures.
- Resolving tickets assigned to tools on 24X7 basis (ServiceNow,Taskman,ResolveITand some Internal Client Designed tools)
- On-board new clients. We assist clients in setting up their applications to use above tools.
- Supporting clients who are using Hermes/Build Portal to build, package, and deploy their applications.
- Understand how to use mentioned tools and explain errors they encounter when using above tools.
- Direct users to appropriate documentation to help them resolve their specific issues.
- Perform development assistancerole, for example, we move source trees from one app id to another, move packages from one source tree to another, retire source trees, add new files suffixes to the list of supported file suffixes in config files (pkg.cfg), install 3rd party products, update product compatibility information, retireproduct versions, Establishing ACL control on XENV components, Transferring licenses from one user to another, Granting/Revoking Application access
Confidential
Team Member
Responsibilities:
- Installation, Maintenance, Administration and troubleshooting of Sun Solaris, Linux, AIX, HP-UX.
- Performed automated installations of Operating System using Jumpstart for Solaris and Kickstart for Linux.
- As a Solaris administrator primary responsibility includes building of new servers which includes rack mounting, installation of OS, configuring of various OS-native and third party tools, securing of OS, installing & configuring, job scheduling.
- Installation and configured Solaris 10 with Zone configuration.
- Install and configure DHCP, DNS (BIND, MS), web (Apache, IIS), mail (SMTP, IMAP, POP3), and file servers on AIX and Linux servers
- Maintained and Managed user accounts and user permissions
- Provided support with security patching as required during system upgrades
- Maintained the Repository with custom packages and patches that were locally developed.
- Installing & configuring HP Performance Centre 9.5and 9.1and creating test projects and performing testing.
- Troubleshooting issues related to load testing in HP Performance Centre 8.x/9.x and VuGEN.
- Troubleshooting issues related to Vugen and load runner and assisting application team for the same.
- Supporting & Assisting clients who are using the Performance Centre 9.5 (productionenvironment ), to run their scripts and perform load test.
- We also perform administrative functions for the PerformanceCentre. For example, onboarding Projects, Granting/Revoking Project access, modifying Project details etc.
- Restarting orstoppingservers, rebooting host domain, host Domain creationetc.
- Performed DB Migrations for HP Load Runner with coordination ORACLE DB team.
- Performing COB for application to verify its reliability.
- Installed and configured Tarantella for host access user interface.
- In tarantella created icons, addicons, host establishments, add usersetcto have direct access to respective servers.
- Performed Servers consolidation and virtualization using VMware virtual infrastructure, VMware ESX, Virtual Center, VM tools.
- Installation of CA Willy Introscope in Linux/Solaris/Windows Server.
- LDAP configuration and management for Introscope Willy.
- Maintaining and creating zones and projects in tarantella.
- Develop, Maintain, update various script for services (start, stop, restart, recycle, and Cron jobs) UNIX based Korn, Bash shells.
- Perl/Python scripting creation and update experiences.
- Involved in Disaster Recovery testing every quarter.
- Troubleshooting of day to day system and user problems with ITIL standards in ticketing system.
- Used VMware for testing various applications on different operating systems.
- Interacting with various teams such Oracle database team, and Net Backup team.
- Troubleshooting various problems, logging call with vendors.
- Participated in on-call rotation to provide 24x7 technical supports.
Confidential
MS SQL DBA Consultant
Responsibilities:
- Worked in Support Environment(8X5) for L1,L2 level Tasks.
- Installation and Configuration of SQL Server 2000 and 2005.
- User Management and configuration management in SQL server.
- Backup Restoration & Performance monitoring.
- Created Database Backup Plan.
- Executed sql scripts and confirmed output to Clients, and helped in troubleshooting errors.
- Database Troubleshooting.
- Technical documentation Preparation.
- Technology experienced Windows 2000/2003 Server, MS SQL 2000, MS SQL 2005.
Confidential
Network Engineer
Responsibilities:
- Installing SOLARIS 8&10 on V-240 R Server.
- Installation and configurations of Solaris 8/10, Redhat 4.x, SUSE,Windows2000/2003 as active client servers
- Creating zones for ORACLE, APACHE and SAMBA.
- Installing and configuring Oracle 8database on Sun Solaris Servers.
- Install and configure SAMBA, NFS and FTP servers.
- Implemented Xen and VMware environments.
- Mounting, un-mounting, Partitioning and creating new file systems.
- Implemented mail server with send-mail servers.
- Installating and configuring monitoring tools such as netcool, nagiosetc on unix/windows server.
- Installing and configuring Cisco Routers and Switches and defining and configuring port as per requirement.
- Performing and verifying SMTP, SNMP, DHCP, POP, SMB, NIS, NIS+, NFS, DNS, FTP/TFTP, ARP/RARP, SSH, TCP/IP, WEBSM, NTP, TELNET etc.
- Co-ordination with Client.
- End-to-End Co-ordination with all team members.
- ConfiguringDNS, DHCP on the main server.
- Install and configure software’s as per project requirement.
- Working with Logical Volume Manager for creation for volume groups/ logical volumes and file systems in Red Hat Linux environment.
- End-to-End communication routing and protocol set-up design creation.
- End-to-End Co-ordination with all team members.
