Database Devops Engineer Resume
MO
SUMMARY
- More than 7 years of System Engineering, IT operations, web application and development experience. Great hands on experience on Configuration/Release/Build engineering, Release management, Development Operations, Continuous Integration/Continuous deployment..
- Design and implementation of DevOps work flow for automating MS SQL database from Dev DB to Production DB.
- Documentation of all DLM Process using DLM automation and created on boarding documents for developers and leads.
- Presentation of DevOps architecture to higher level and collaborating with them to update the design to serve their technical need.
- In - depth knowledge of network technologies, Linux based operating systems and Microsoft Windows operating system.
- Experience with DevOps methodologies implementing Continuous Integration / Continuous Delivery Pipelines using tool sets like GIT, Jenkins, Gradle and Ansible,Docker,Kubernetees.
- Extensive experience on working with the Configuration/Deployment Tools like CHEF (Knife, recipe, cookbook), ANSIBLE (Playbook, inventory) and PUPPET (Puppet manifests, Factor, catalog)
- Worked with Terraform for infrastructure configuration and deployment.
- Worked with Elastic Beanstack’s config file to updated changes to default config file to address the environment change request from developers.
- Transforming Manual code migration from one stage to another using Jenkins and powershell (DLM Automation cmdlets) to help administrators, mostly SQL DBA.
- Experience in all phases of the Software Development Life Cycle (SDLC) in both water fall and Agile environments with demonstrated success in the deployment of large-scale enterprise applications.
- Manages, uses, deploys, and configures cloud-based hosting and services providers or website-building services, such as Godaddy, Bluehost, AWS, Google, Microsoft Azure, Squarespace, and Wordpress.
- Strong Knowledge to exploit Configuration Management tools like Ansible, Chef, Puppet and Saltstack.
- Advance knowledge for utilizing version control system like GitHub, GitLab, Bitbucket.
- Experienced with IDE like Eclipse, NetBeans, MS Visual Studio, SSMS and integrating them with tracking tools like JIRA and Mingle.
- Expert Knowledge of Apache Ant, Maven and Gradle for Project Builds.
- Well Experienced in utilization of Redgate tools to create CI/CD pipeline by using various DLM Automation plugins and powershell cmdlets.
- Working Knowledge of testing tools like Selenium, Junit and Nunit.
- Experience in building deployment pipelines to Docker.
- Administrative Knowledge for Cloud environment for AWS and Microsoft Azure.
- Developed various cloud formation files to define the virtual environment in VMware, AWS and Azure.
- Automated tests of cloud formation and Terraform files using Server Spec and Test Kitchen.
- Experienced with Platform as a service with PCF (Pivotal Cloud Foundry)
- Developed automation and deployment utilities using Ruby, Bash, Powershell, Python.
- Experienced with Red Hat Linux Servers for different application implementations
- Lead Build and Release activities for many High Availability Java applications including real time web applications, web based analytic applications and intranet applications.
- Worked on writing Maven pom files from the scratch for multi module projects as a team.
- Knowledge on databases like MySQL, SQL Server, Big data & Oracle.
- Refined automation components with scripting and configuration management using Configuration management tools like Ansible, Chef and Puppet.
- Worked on creating a Docker container that contains a list of information and also able to read the configuration from outside the container
- Responsible for OS installation and configuration through network and standalone installation techniques and also installing third party software and services.
- Managed Firewall for small networks using Opensource PFSense. Configured it to create different LANs and hosted Company’s website on DMZ for security purpose.
- Configured LAMP and WAMP servers for web apps development in different scenarios.
- Created ELK stack to analyze the logs in a graphical figures and stats. Using Beats and Logstash to collect data and pipeline them to Elasticsearch analytic engine and visualize it in Kibana for data mining and troubleshooting at times.
- Created WSO2IOT server for enterprise mobile device management and documentation. All androids and ios modules were configured as a service in Linux server.
- Created a web conferencing server for a enterprise using open source BigBlueButton server.
- Created a Cloud storage for an enterprise utilizing Owncloud open source server and reconfigured it to cutomize according to company’s need.
- Created a Elastix server to set-up IP phone and fax based on PBX and SIP services for an enterprise.
- Created automation and deployment templates for relational and nosql databases (standalone and RDS), including MSSQL, Mysql, MongoDB, Redis and Neo4j.
- Experience managing various file systems using VxVM, LVM and SVM and also configured file systems through network using NFS, NAS methodologies and installed RAID devices. Worked in both FreeNAS (Preferred) and NAS4FREE.
- Worked along with Monitoring teams to identify and troubleshoot issues on servers using tools like Nagios, Icinga 2, WireSharks.
- Experienced in customizing the Kickstart and Jumpstart scripts to automate the installation of various servers used for various internal projects.
- Worked on Backup and Disaster Recovery operations of various servers and workstations. Deltacopy client was run in a scheduled time using corn jobs in various servers and rsync in NAS4FREE was used to collect the data in main backup server. Then CrashPlan was used to store the main backup server in Cloud for Diaster Recovery.
- Working Knowledge on using and developing basic shell and python scripts used to automate day to day administrative tasks.
- Experience in installation, configuring, monitoring, supporting of DataNodes, NameNodes, Secondary Namenodes, HDFS.Excellent Knowledge of SDLC, STLC and Development Methodologies like Waterfall and Agile Methodologies.
- Expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management using hp Quality Center 10.1 and JIRA.
- Strong experience in writing Shell scripts covering data feed handling, implementing business logic, communicating with web-services through SOAP Lite module and WSDL.
- Setup and troubleshooting Vpn (OpenVPN), Intranet, Citrix access, Application, and other various applications for users.
- Analyzing, troubleshooting and resolving system hardware, software and networking issues
- Established NAS with RAID 5 implementation, created network shares for users and departments.
TECHNICAL SKILLS
Virtualization: Hyper-V,VirtualBox, VMware, Vagrant, Amazon Web Services, Microsoft AZURE, Digital Ocean, Docker,PCF (Pivotal Cloud Foundry),Terraform
Configuration management systems: Ansible, Chef, Puppet, Saltstack
Continuous Integration/Delivery: Jenkins CI, Bamboo, Capistrano,DLM Automation
Languages: JAVA, PHP.Ruby, Bash, SQL, PL/SQL, HTML/CSS
Version Control Systems: GIT, GITHUB, CVS, SVN, Team Foundation Version Control
Build Tools: ANT, MAVEN,Gradle, MS-Build
Web servers: Apache, Nginx, Unicorn, Tomcat
Monitoring/Logging: Prometheus, Zabbix, Icinga2 (Nagios fork), Syslog, Logstash, Tcpdump Intrusion Detection and Prevention systems- Snort, Suricata, Security Onion,OSSEC
DB's & Brokers: MS SQL with Redgate Tools, Oracle (SQL Plus, TKPROF, AWR, Explain Plan, cost-based optimization), MySQL,MongoDB, RabbitMQ, ActiveMQ
Operating Systems: Linux, Mac OS X, Windows, Red Hat Linux
Networking: TCP/IP, Load balancing, DHCP, RADIUS, Netflow, SNMP, CDR, DNS, HTTP, SSL,FTP, SSH
ESB: MuleESB
Tools: Oracle SQL Developer, Visual Studio, JetBrains, Atom, Eclipse, FreeRADIUS, Wireshark
Business-software: Activiti BPM Platform, SugarCRM, Oro platform, Pentaho BI,CA Agile (Rally).JFrog Artifactory
PROFESSIONAL EXPERIENCE
Confidential
Database DevOPS Engineer
Responsibilities:
- Design various DevOps Strategy to implement MS SQL database and to present them to the high level managers and discuss the pros and cons of those strategies to find the best one.
- Documented all process and created On-boarding documents for developers to version control database using SSMS and Redgate source control.
- Created Document for GateKeeper/Leads to handle pull requests and merge devlopment and feature branches to feed the branch to the build server to create an automatd sql script to deploy on test, stage and production server.
- Filter out all environmental differences using customized filters and data compare options between Dev and Test, Test and Stage and Stage and Production server.
- Create CI/CD pipeline DLM Automation using Redgate Toolkits to automate the MS SQL database from Dev DB to Stage DB where Stage DB was in different environment (LHI)
- Saved builds output, nukpg package and .sql script in Jfactory artifactory before linking them to UDeploy for deployment versions.
- Created deployment for different environments in udeploy utilizing artifacts from jfactory and components.
- Train Developers (on-shore and off -shore) and Leads on the DLM automation process and helped them to understand their roles and duties in the whole process
- Experimented with different Git branching strategies to fit the requirement from system architect.
- Attend daily Scrum call and provide report on the progress on user stories and tasks assigned.
- Created an automated task to compare two DBs using filters and comparisions options and create a script which can be edited if necessary by lead before deploying it to the target server using DLM Automation Powershell cmdlets.
- Created post build auto sync tasks to synchronize two different DBs and to script out the differences.
- Made sure that the DevOps strategy is compliant with standard process.
Confidential, MO
IT Administrator/ DevOPS Engineer
Responsibilities:
- Developed build and deployment processes for pre-production environments.
- Worked closely with the development and operations organizations to implement the necessary tools and process to support the automation of builds, deployments, testing and infrastructure (infrastructure as code) using Chef.
- Developed Chef recipes to configure, deploy and maintain software components of the existing infrastructure
- Administered Jenkins and secured Jenkins with role based access controls.
- Setup all different kinds of projects in Jenkins ranging from software to maven style projects and matrix based projects
- Managed SVN/Git repositories for branching, merging, and tagging using GitHub.
- Developed Shell/Perl Scripts for automation purpose.
- Resolved merging issues during re-basing and re-integrating branches by conducting meetings with Development Team Leads.
- Used Chef to manage Web Applications, Configure Files, Database, Commands, Users and Packages and automate Configuration management & Applications.
- Experience with TFS 2010+, VSTS, or similar ALM tool
- Installed, configured and administered Jenkins CI tool on Linux machines.
- Assisted developers with establishing and applying appropriate branching, labeling/naming conventions using GIT source control.
- Implemented the setup for Master slave architecture to improve the Performance of Jenkins.
- Used to write queries in order to deploy on different environments.
- Created and restored database backups like SQL server and MYSQL.
- Used BotoS3 in creating the S3 buckets and used these S3 buckets and glacier for storing and backing up for the AWS .
- Maintained build related scripts developed in ANT, shell and Python. Created and modified build configuration files including Ant's build.xml.
- Manage AWS EC2 instances utilizing Auto Scaling, Elastic Load Balancing and Glacier for our QA and UAT environments as well as infrastructure servers for GIT and Puppet
- Implementation of DevOps environment using Chef for system configuration across environments.
- Connected continuous integration system with GIT version control repository and continually build as the check-in's come from the developer.
- Configured Jenkins for Continuous Integration and designed and created several CI jobs utilizing various plugins ins Jenkins.
- Own full life cycle of build system - from analysis, development, implementation and support of builds, unit testing and deployments.
- Interacted with developers and Enterprise Configuration Management Team for changes to best practices and tools to eliminate non-efficient practices and bottlenecks.
- Coordinated with Release Management regarding appropriate system releases among other development platforms.
Environment: Amazon Web Services, Chef, Vagrant, GIT, Maven, DB2,, PRTG, Shell Scripts, Tomcat,Apache HTTP
Confidential, MO
Windows Systems Administrator
Responsibilities:
- Planning, installing, configuring systems,designing, creating storage, networking and other system components,designing and implementing High Availability and Disaster Recovery for each system using Microsoft Azure.
- Re-balancing workloads across servers based on monitoring
- Designed, installed, administrated and maintained Microsoft Active Directory components (AD, Azure AD, GPOs, File, Print) to ensure business enablement.
- Served as the Subject Matter Expert (SME) on cloud-based (Azure) business offerings, for all ongoing and future decision making, worked directly with IT Infrastructure Architects to develop the cloud roadmap for the Organization.
- Maintain complete accountability for monitoring and troubleshooting devices from NT, Windows, XP, HP Unix, Sun Unix, Switches and router platforms; resolve functionality issues, troubleshoot system issues, and apply security patches to ensure maximized performance.
- Expertise in resolving file system and service issues utilizing Sun UNIX, HP UNIX, Windows NT, XP applications; ensure a robust and stable system, collaborate with vendors to resolve interoperability issues.
- Utilized Hyper-V to migrate servers from a physical to a virtual environment; provide ongoingtroubleshootingand support.
- Securing systems, networks and individual computers based on requirements and implementation in Azure.
- Planning, implementing and controlling user and account security rights and restrictions in Azure.
- Developed organizational units in Active Directory (AD) and managed user security with group policies.
- Planned, developed, and implemented IT solutions as and when needed.
- Ensure system connectivity of all servers, shared software and other applications.
- Strong understanding of Windows system administration, installation, security, user management, networking, disk configuration.
- Upgrade, Migration of MS SQL Server 2008 to MS SQL Server 2012 using suitable approach.
- Lowered spam by 80% using firewall filtering with real-time spam black lists for incoming email.
- Installed, configured, and updated server-based applications, including accounting system and records database.
Environment: Microsoft Azure, Windows, MS SQL Server, Active Directory 2008, MS Visual Studio, WAMP
Confidential
UNIX/LINUX Administrator
Responsibilities:
- Installation, Configuration & Upgrade of Solaris, Linux (Red Hat Linux and SuSE), HP-UX, AIX operating system.
- Responsible for administration and maintenance of 50 machine network consisting of Windows NT, IRIX, SunOS and NCR servers and work stations. We work on measurement base capacity planning and sizing.
- Installation, Configuration & trouble Shooting of VxVM under Sun Solaris 8/9, Linux. Experience with Volume creation re-sizing and troubleshoot to the client’s development/production environment using Veritas volume Manager.
- Experience in configuring Red Hat Cluster Suite, Veritas Cluster Server, Sun Cluster and HP Service Guard.
- Design and development of internal websites and web applications using LAMP and WAMP.
- Installation of patches and other software packages.
- Creating the volumes and creating the file systems (UFS and VxFS).
- Configuration of NIS, NIS+, DNS, NFS, Sendmail, Samba, Apache for multiple environments.
- Installation, Configuration and Administration of WebSphere and WebLogic Servers.
- Monitoring System performance and do kernel tuning to enhance the system Performance.
- Setup and maintained DNS Primary, Secondary, Cache-only servers, DHCP servers and DNS clients.
- 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.
- Application & Production Support (Bridge Call 24/7)
- Desktop support provided to end users installation of windows NT/2003.
- Ensure that all computers are in perfect operating condition at all times.
- Establish security and control measures on the use of computers.
- Follow up change management procedure & implement the documentation standard as per requirement.
- Actively involved in technical discussions to provide/design solutions for various application teams
Environment: Red Hat Linux 5/6/7, Solaris 8,9,10, E 6500/5500/4500/10 K/15K class servers RHEL5/6/7, AIX 5.2, HP-UX 11.x and Windows NT, Veritas File System 3.0, Veritas Volume Manager, WebSphere 4/5, WebLogic, ORACLE 8/9.
