Sql/nosql Dba And Aws Devops Resume
TN
SUMMARY
- Over 10+ years of total IT experience working on MSSQL/NOSQL (Cassandra, MongoDB) Database Administrator and AWS DevOps.
- Served as AWS DevOps for Applications located in AWS including EC2, EMR, RDS, Redshift, S3, VPC, ELB, SNS, Route53, IAM, lambda, Kinesis, Auto scaling, with Cloud watch metrics integration.
- Implemented rapid - provisioning and life-cycle management for Ubuntu Linux using Amazon EC2, Chef, and custom Bash scripts
- Managed both Jira, and Confluence installations, including upgrades and adding user features.
- Optimized current infrastructure and implemented changes to increase uptime and service efficiency.
- Implemented Auto-scaling and created a process to auto-scale front end infrastructure to adjust on traffic increases.
- Identified and informed development teams to remove single points of failure within applications.
- Maintained an environment of EC2 instances and physical hardware.
- Found reasonable uses for AWS Solutions to provide increased service availability and cost optimization using Trusted Advisor.
- Created automation for failover measures in case of distributed outage in EC2 environments and RDS Multi set-up.
- CI/CD tools and configuration management tools like CHEF
- Configured Ansible to manage AWS environments and automate the build process for core AMIs used by all application deployments including Auto scaling and Cloud formation template.
- Experience in public, private and hybrid cloud computing.
- Expertise in AWS compute, network, storage and Databases.
- Good knowledge in VPC, Virtual Private Gateway and Direct connect.
- Expertise in AWS route 53 Domain Name Service and Elastic load balancing.
- Experienced in AWS compute technologies like Elastic compute, high availability, fault tolerance, self-healing and monitoring.
- Experience in Monitoring/ Alerting systems using ELK (Elasticsearch, Logstash, Kibana) and Cloud Watch alarms.
- Experience in AWS storage services like S3, IA, Amazon Glacier and Storage Gateway.
- Good knowledge in AWS Content data Network (CDN) like cloud front.
- Experienced in in setting up of AWS relational databases like Aurora, MYSQL, MSSQL, and NoSQL database DynamoDB.
- Experience in monitoring and auditing tools like AWS Cloud Watch and Cloud Trial.
- Good knowledge in creating AWS Identity Access Management like user’s roles, groups and policies.
- Good understanding of the DevOps philosophy and contributed Chef Code to automate infrastructure and Cloud Formation.
- Very Good knowledge on LINUX.
- Used scripting languages like Python, Bash and configuration management tools Chef.
- Experience with version control tools such as GIT, CVS, Bitbucket, SVN
- MSSQL Design, Analysis, Modeling, Development, Support and Administration of Microsoft SQL Server 2012/2008R2/2008/2005, T-SQL
- Hands on experience in Migration of SQL Server 2008/R2 to 2012, 2005 to SQL Server 2008 and SQL Server 2000 to SQL Server2005 (side by side and in place).
- Applying Service Packs (SP) and hot fixes for SQL Server and Windows Operating Systems.
- Experience on database migration from MS Access, Oracle, and MySQL into SQL Server 2008.
- Upgrading databases from SQL Server 2005/2008/2008 R2 to SQL Server 2012.
- Experience on Deploying Databases in Test, Development and Production environment.
- Profound experience in creating and supporting database administration scripts & scheduling jobs.
- Creating Clustered, Non-clustered and Full-Text Indexes.
- Configured Active/Active and Active/Passive clustering for failover.
- Performed Capacity Planning, data modeling and Logical/Physical database Design.
- Experience in Database Backup, Recovery and High Availability (Clustering, Log Shipping, Replication and Mirroring).
- Configured and maintained Transactional and Snapshot replication.
- Experience in setting up Database Mirroring with witness Server in SQL server 2008 R2 (Manual / Automatic fail-Over).
- Experience in optimizing of linked servers, Bulk Insert, Open row set functions
- Experience in tools like SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
- Experience working with Microsoft Team Foundation Server
- Involved in package migration from DTS packages to SSIS packages, running the Microsoft upgrade advisor tool
- Strong knowledge of star schema, snow flake schema in dimensional modeling and their usage in different data modeling design
- Involved in all phases of database modeling: conceptual, logical and physical ex: Erwin and MS.Visio
- Working experience in configuring and administering High Availability Databases like Database Mirroring, Replication, Log shipping, Clustering, Backups and Restore.
- Experience in Performance Tuning by using SQL Server Native Tools (Execution Plan, Profiler and Database Tuning Advisor) and Windows Performance Monitor.
- Knowledge in Third-Party performance monitoring tools (SpotLite, Idera SQL Diagnostic, Foglight monitoring, Nagios, Evanios)
- Good customer support experience in providing end-user support on a day-to-day basis.
- Knowledge on working with SAN and RAID.
- Working in Linked and Remote Servers to run queries between SQL servers and other data sources using ODBC, OLE DB drivers.
- Good experience in writing and debugging SQL Server stored procedures and triggers, and documenting issues/resolutions of SQL Server Applications.
- Excellent analytical/Communication Skills, Team Play and very much result Oriented.
- Data Modelling for Production environments
- Time-Series Data modelling.
- Architectural Review for New DB requests.
- Cassandra Configuration, Tuning and Administration
- DSE Cassandra upgrade from 3.X to 4.X.
- Cassandra installation and Administration on AWS EC2.
- Cassandra Performance tuning. Tweaking Cassandra.yaml Parameters
- Node addition and removal in Cassandra
- Cassandra Opscenter configuration and Migration
- Cassandra utilities like Nodetool, cqlsh, SStablescrub
- Data migration in Cassandra
- Cassandra-stress test
- Troubleshoot read/write latency and timeout issues
- Configure backup, alerts, repairs and monitoring of Cassandra clusters
- MySQL to Cassandra Migrations
- Backup, recovery and PITR for Cassandra Production Environments
- Opscenter 5.X Installation, configuration and administration.
- No-SQL database MongoDB:
- 24×7 production support experience
- Skilled in backups & disaster recovery
- Experience in performing Mongo DBA operational routines
- MMS configuration experience
- Configuring and monitoring replica sets
- Optimizing database/query performance
- Configuring Sharding, monitoring, and identify the proper shard key
- Selection, inserting large amounts of data
- Performing Security measures, backups and restore backups
- User Management - creating users, assigning roles, managing permissions.
- Performed DR testing on MongoDB annually.
TECHNICAL SKILLS
Database: MS SQL Server 2005/2008/2008 (R2)/2012, Oracle 10g, Access 2003/2007/2010 , Cassandra, MongoDB, DynamoDB, AWS RDS and Redshift
Server Tools: SSMS, BIDS, SQL Server Profiler, Fog Light, Nagios, lightspeed, SQL Santry, Foglight, SSTable loader, DBeaver, Nodetools, Hive, Hue, Squirrel, Eclipse, PtDev, PyCharm, SQLBench, Compare, Encryption tool, atom, Performance Monitor, Database Tuning Wizard, OpsCenter, MMS, Evanios
Web Technologies: HTML, JavaScript, CSS, XML, XSLT
IDE's & Tools: Visual Studio 05/08/10, Net Beans, Matlab, Simplescalar, (Architecture Simulation Tool)
BI(ETL/OLAP/Reporting): SSIS/SSAS/SSRS/RedShift/Hadoop/S3
Programming Language: .NET,VB.NET, T-SQL,CQLSH, Linux, Python, Nodejs, Java
PROFESSIONAL EXPERIENCE
Confidential, TN
SQL/NOSQL DBA and AWS DevOps
Responsibilities:
- Worked on AWS cloud services like EC2, S3, RDS, ELB, and EBS for installing, configuring and auto scaling.
- Experience in installation, configuration, backup, recovery, maintenance and support for RDS, Dynamo DB and RedShift.
- Experienced in creation and management of user accounts, security, disk space and process monitoring.
- Worked on AWS IAM to grant fine grained access to AWS resources through configuration of roles, policies and wed identity federation. Configured S3 versioning and life-cycle policies to backup files.
- Configured AWS Cloud Watch to monitor AWS resources and applications alone with Foglight monitoring tool and Evanios.
- Configure Amazon VPC environment.
- Migrate AMI’s of EC2 Instance between Amazon AWS regions. Worked on Launch an EBS Optimized EC2 Instance with a Provisioned IOPS Volume.
- Responsible for creating EBS volumes from the snapshots and attaching it the EC2 Instances.
- Worked ON RDS, Aurora, MSSQL, MySQL and DynamoDB and Petabytes store Redshift database to perform basic database administration. Configuring multi availability zone and read replica for workload sharing.
- Utilize AWS CLI to create and access Resources.
- Created S3 buckets for EC2 instances to store all the content including HTML pages, images, CSS files and script files. Generate S3 policies and manage S3 bucket permission. Worked on Encrypting AWS S3 storage Objects.
- Worked on Python Integrated Development Environment using Pycharm. Used Boto3 and Python to automate EC2 actions like launching instances and creating snapshots. Scripts to update content in the database and manipulate files.
- Setup ELB (Elastic load balancers) to distribute traffic to multiple availability zones and configured stickiness (instance affinity) using cookies to bind a user's session to a specific instance.
- Knowledge of DNS route 53 and configurations and hosting static website.
- Worked on Agile development methodology in Devops Team. Understanding the Business needs of stories and creating tasks for the sprint to be performed.
- Knowledge on IP protocols, DNS naming convention and firewall protocols.
- Interacting with Developers for standard on premises deployments for POC/Dev/QA and Prod.
- Impediments are Troubleshooted with continuous meetings and daily stand up.
- Monitoring Deployed applications and troubleshooting the errors through Cloud Watch, Foglight monitoring and Evanios.
- Inventory groups are added for Amazon Ec2 for instances and monitoring AWS hosts.
- Monitor Cassandra clusters, MongoDB, ParAccel and ensure they are always available
- Adequately scale clusters and stay ahead of the demand
- Maintain backup and recovery process
- Database testing
- Carry out non-intrusive rolling upgrades in production
- Develop and implement fail-over, back up, and recovery plans to keep servers operational
Environment: MS SQL Server 2008/2006R2/2012, SSIS/SSAS/SSRS 2008, T-SQL, Visual Studio 2008/2010, VB.NET, ASP.NET, Oracle11g, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Business Intelligence DevelopmentStudio (BIDS), FogLight Monitoring tool, Nagios, Evonios SQLCompare, SQLSantry, OpsCenter, MMS, SSTableloader, DBeaver, Nodetools, Hive, Hue, Squirrel, Eclipse, PtDev, PyCharm, SQLBench, Evanios
Confidential, TN
SQL/NOSQL DBA and AWS DevOps
Responsibilities:
- Working as a Devops Engineer on cloud computing Technologies.
- Working in AWS Public cloud, continues Integration and continues deployment(CI/CD), CHEF
- Implementation knowledge on Jenkins
- Developing high availability, fault tolerance, self-healing and monitoring system.
- Developing, modifying, supporting and maintaining AWS-based components for public facing infrastructure and application back-end.
- Configuring VPC, Route53, ELB, EC2, S3, RDS EMR, AWS components
- DynamoDB table, SNS, User creation, Role configuration.
- Responsible for documentation and work allocation.
- Involved in testing and coordinated for integration testing.
- Deploying applications on AWS Cloud.
- Infrastructure Modernization, Monitoring systems experience
- Writing Automation scripts using Ansible and Chef.
- Created multiple environments like Integration, Development and Release in AWS public cloud.
- Monitor Cassandra clusters, MongoDB, ParAccel and AWS ensure they are always available
- Adequately scale clusters and stay ahead of the demand
- Maintain backup and recovery process
- Database testing
- Carry out non-intrusive rolling upgrades in production
- Develop and implement fail-over, back up, and recovery plans to keep servers operational
- Reviewing the code and committing the change before release..
- Knowledge on IP protocols, DNS naming convention and firewall protocols.
- Interacting with Developers for standard on premises deployments for both POC/Dev/QA and Prod.
- Monitoring Developed applications and troubleshooting the errors through Foglight monitoring and Evanios.
- Providing support for periodic database upgrades and Linux patching by backups as well as maintenance of hardware such as disk, system board and CPU upgrading.
Environment: MS SQL Server 2008, 2006R2, 2012 SSIS/SSAS/SSRS 2008, T-SQL, Visual Studio 2008/2010, vb.NET, ASP.NET, Oracle11g, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), FogLight Monitoring tool, Nagios, Evanios, SQLCompare, SQLSantry, OpsCenter, MMS, SSTableloader, Nodetools, Hive, Hue, Squirrel, Eclipse, PtDev, PyCharm, SQLBench
Confidential, TN
Database Administrator and AWS DevOps
Responsibilities:
- Worked on AWS compute technologies like Elastic compute, high availability, fault tolerance, self-healing and monitoring.
- Experience in AWS storage services like S3, Amazon Glacier and storage gateway.
- Good knowledge in AWS Content data Network (CDN) like cloud front.
- Experienced in in setting up of AWS RDS and Dynamo DB instances.
- Experience in monitoring and auditing tools like AWS cloud Watch and Cloud Trial.
- Good knowledge in creating AWS Identity Access Management like user’s roles, groups and policies.
- Good understanding of the DevOps philosophy and contributed Chef Code to automate infrastructure and Cloud Formation.
- Developing high availability, fault tolerance, self-healing and monitoring system.
- Developing, modifying, supporting and maintaining AWS-based components for public facing infrastructure and application back-end.
- Configuring VPC, Route53, ELB, AWS components, Worked on AWS route 53 Domain Name Service and Elastic load balancing.
- DynamoDB table, SNS, User creation, Role configuration.
- Responsible for documentation and work allocation.
- Involved in testing and coordinated for integration testing, deploying applications on AWS cloud.
- MSSQL Responsibility: Involved in Data center Migration project for moving databases across the location.
- Implemented backup strategy for the new data center environment.
- Restored the database on Staging servers and development servers as per requirement.
- Configured high availability methods such as SQL server Replication and mirroring.
- Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
- Troubleshooting performance issues and fine-tuning queries and Reports.
- Coordinate and Perform various deployment in QA environment and then into productions
- Experience in managing the large set of databases that was in TB’s.
- Automate tracking of database disk space utilization process and successfully implemented into production and development system
- Involved in administration of SSIS and SSAS Servers ( Sql Server Analysis Services cube servers)
- Involved in taking Database Backups and restores using Quest SqlLiteSpeed.
- Implemented Log shipping across various SQL Servers in Production
- Involved in Implementing Transactional Replication and also worked various options that optimize the data streaming to reduce the latency from publisher to subscriber in Dev, QA and Production.
- Worked on the configuration of the server like enable the protocol like TCP/IP when the server is newly configured
- Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
- Involved in transformation of data to and from SQL server through SSIS Packages, DTS, and BCP.
- Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing
- Implemented customized alert monitoring setup based on application perspective.
- Applied patches for the SQL server environment after the Migration. .
- Prepared deployment document for migration of Package and reports to Production.
- Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions.
Environment: MS SQL Server 2008, 2006R2,2012 SSIS/SSAS/SSRS 2008, T-SQL, Visual Studio 2008/2010, vb.NET, ASP.NET, Oracle11g, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), FogLight Monitoring tool, Nagios, Evanios, SQLCompare, SQLSantry, OpsCenter, MMS, SSTableloader, Nodetools, Hive, Hue, Squirrel, Eclipse, PtDev, PyCharm, SQLBench
Confidential, GA
Application programmer Analyst
Responsibilities:
- Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging into data warehouse
- Extracted data from data sources Oracle, CSV files, text files, DB2, SQL-Server, Teradata and applied required transformations to clean the data
- Loaded Binary data using SSIS packages
- Used FTP control flow task to access data on the FTP server and moved data into new folders in the client file system
- Used Data Profiling task to check the validity of text files, loaded them into staging database, applied data constraints and then finally loaded in to production
- Studied the existing OLTP system(s) and involved in creating facts, dimensions and star schema representation for the data mart
- Successfully deployed SSIS package into production environment using package configurations to export various package properties which indeed make the package environment independent
- Involved in development and debugging of complex batch T-SQL Procedures and functions
- Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, text, csv files, SAS datasets
- Used XML source in SSIS to read data from xml files into SQL server destination
- Created data source views from SQL Server and MY SQL data sources
- Created custom vb.NET applications and used report viewer control to get the access of reports created using SSRS
- Used named queries and named calculations to modify the data source view
- Worked with star and snow flake schema designs for the financial data-mart
- Created custom time dimensions and worked with role playing dimensions, degenerated dimensions
- Created financial cube on geography and time dimensions along with parent child and balanced hierarchies
- Reported data using excel connecting to analysis services
- Created roles and worked on database level and dimension level security on cubes
- Created aggregations based on year to improve the query performance and optimizing the storage
- Involved in establishing organizational level analytics with help of proclarity
- Worked on data driven based subscriptions
Environment: MS SQL Server 2008, SSIS/SSAS/SSRS 2008, T-SQL, Visual Studio 2008/2010, vb.NET, ASP.NET, Oracle11g, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS).
Confidential
SQL BI Developer SSIS/SSAS
Responsibilities:
- Involved in Data Source layer, data transformation layer, data storage and retrieval layer, analytical layer and presentation layer of business intelligence solution
- Used Linked servers to connect to remote oledb source and joined the data present in oledb source with local data (referred the oledb source more than once).
- Used open row set function for one time access of the other oledb source data
- Data from sources MS SQL Server, Oracle, text files, Microsoft access are extracted, transformed and loaded into a data warehouse
- Involved in the design of star and snow flake schemas for the data warehouse
- Handled inferred and slowly changing dimensions while loading fact and dimension tables respectively
- Involved in package migration from DTS to SSIS, running upgrade advisor tool against DTS packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
- Involved in loading the fact and dimension tables
- Identified and defined fact and dimension relationships
- Involved in the ETL process, used SSIS tasks and transformations to accomplish the ETL process
- Deployed reports on to the report manager and presented them to the users creating custom vb.net applications and asp.net pages
- Created data source views from data sources SQL Server, Oracle
- Included computed columns using named calculations and removed unwanted columns using named queries
- Designed time and geography dimensions including hierarchies
- Created multidimensional optimized cubes using SSAS
- Identified the requirement of partitioning the cube for better query performance
- Involved in processing the cube, calculated members using SSAS
- Used MDX to query the cubes, debugging and supported the purpose of data analysis
- Worked on back up of cubes, aggregations and dimension level security of cubes
- Created different drill down and parameterized reports depending on the requirements and developed data driven subscriptions for those reports using SSRS and report manager
Environment: MS SQL Server 2008, SSIS/SSAS/SSRS 2008, T-SQL, Visual Studio 2008, vb.net, asp.net, SQL Server Profiler, SSMS, BIDS
Confidential, GA
BI Developer
Responsibilities:
- Worked extensively with SSIS to import, export and transform the data from oracle, xml and text files
- Extensively used Merge command as alternative to small SSIS packages in dimension and fact load
- Used several SSIS control flow and data flow transformations as part of ETL
- Deployed SSIS packages with minimal changes using XML config file
- Involved in business analysis and technical design sessions with business and technical staff to develop dimensional models, requirements document, and ETL specifications
- Created database objects like Procedures, Functions, Triggers, Indexes
- Involved in Unit testing, User Acceptance testing to check whether the data is loading into target, which was extracted from source systems
- Used SQL Profiler to optimize Stored Procedures
- Involved in all phases of database modeling
- Modified star schema and identified the requirement of snow flake schema in the design
- Loaded fact and dimension tables as part of modified data warehouse solution
- Build an analysis services database on already existing data warehouse solution
- Created measures, measure groups, dimensions and multi-dimensional cubes
- Created tabular reports, list reports, parameterized reports, ad-hoc reports, drill down reports according to business requirements in time restricted environment
- Used c#.net asp web pages to show the deployed reports as required by the user
- Involved in creating, structuring, formatting using report designer
Environment: MS SQL Server 2005, SSIS, SSAS, T-SQL, Windows Sever 2003, SQL Server Management Studio, SQL Profiler