Meenakshi
Westborough,Massachusetts
Summary
I am trained and experienced in Azure DevOps and certified in SQL server admin. Having 10+ years of experience in DevOps and Microsoft SQL Server Database Administration, databases ranging from GBs to TBs in size. Dedicated student interested in applying excellent communication and interpersonal skills to DevOps Engineer role. Experienced in data entry and handling money. Can quickly memorize product details and build customer relationships. Smart DevOps Engineer with career spent in IT designing and planning. Talented leader with extensive knowledge of high availability architecture and concepts. Ready to tackle new challenges in project planning and development capacity.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Info Security Engineer-AVP
Wells Fargo
Bengaluru, Karnataka
05.2020 - 06.2023
- I work on deployments in production as well as lower via TFS and now I am also working on containers and terraform IAC (infrastructure as code) tool that has helped us in build, change and version cloud and on prem resources safe and efficiently across all environments
- I also work on monitoring jobs on sql server agent and autosys and troubleshooting failures
- I am also working on SSRS, SSIS and work on managing permissions and access
- I work on working closely with developers and other teams to oversee the code releases for SQL as well as websites which even includes maintenance and update as well
- Coordinated testing and validation procedures through software development lifecycle.
- We as devops do monitor the feedback and responses of the users to new releases of a product.I am well acquainted with devops tools like GIT, Jenkins, kubernetes, ansible , splunk.I am also working on azure cloud here in wells fargo
- I am also working in migrating the on premise SSRS reports to AZURE cloud with developers
- I am supporting multiple applications
- We have Incident queue to monitor on everyday basis
- I work in password updates for service accounts on regular basis because we are responsible for maintaining the security and make the security accounts on regular basis because we are responsible for maintaining the security and make the environment secure for the customers
- I work on monitoring Incidents as well creating and scheduling change requests for deployments via ServiceNow.Worked closely with the technical and support teams to deliver and manage services with high uptime Advocate for automated processes to improve quality, deployment, and support of multiple products Build and maintain solutions and tools for automated builds, deployment, monitoring, and operations
- Troubleshoot, perform root cause analysis, and implement fixes for deployment and infrastructure issues
- Builds new environments and updates existing environments through use of automation
- Devised automation, backup and recovery protocols to preserve and safeguard data.
- Maintain cloud infrastructure for multiple products and services
- Infrastructure as code design, deployment and maintenance.
Cloud Migration and Impl. Senior Analyst
Accenture
Bengaluru, Karnataka
01.2020 - 04.2020
- Performed ad-hoc analyses using SQL queries to extract relevant information from large datasets.
- Reported on common sources of technical issues or questions and made recommendations to product team.
- Developed actionable roadmaps for improving workflows and processes.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
- Monitored and optimized database performance using indexes, stored procedures, triggers, and other techniques.
- Created tables, views, functions, stored procedures and other database objects.
- Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
- Researched new features available in the latest version of SQL Server software to determine their usefulness.
- Troubleshot complex SQL queries to identify problems or potential improvements in performance.
- Maintained disaster recovery plans including backup schedules and testing procedures for recovering from unforeseen events.
- Provided technical support for applications that use the database system by troubleshooting errors or providing advice on optimizing queries.
- Coordinated security compliance and audit preparation with cyber security team.
SQL Server Database Administrator
Tata Consultancy Services
Bengaluru, Karnataka
08.2017 - 01.2020
- Defined database design specifications based upon project requirements.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
- Aligned systems with business needs to enhance scalability of database structures and recommend improvements.
- Wrote scripts and processes for data integration and bug fixes.
- Consulted with internal departments to identify customer needs to include in project objectives.
- Collaborated with stakeholders to gather business requirements for enhancements and change requests.
- Monitored and optimized database performance using indexes, stored procedures, triggers, and other techniques.
- Created tables, views, functions, stored procedures and other database objects.
- Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
- Researched new features available in the latest version of SQL Server software to determine their usefulness.
- Troubleshot complex SQL queries to identify problems or potential improvements in performance.
- Maintained disaster recovery plans including backup schedules and testing procedures for recovering from unforeseen events.
- Provided technical support for applications that use the database system by troubleshooting errors or providing advice on optimizing queries.
- Assisted with capacity planning efforts by forecasting usage trends based on historical data.
- Performed daily maintenance tasks such as backups, restores and log shipping operations.
- Automated routine tasks using PowerShell scripting language to streamline processes and reduce manual workloads.
- Analyzed existing databases for opportunities to improve efficiency through restructuring or re-indexing.
- Deployed patches and upgrades according to established change management policies.
- Implemented replication between multiple servers to ensure high availability of the system.
- Coordinated with developers on schema design decisions related to application development projects.
- Performed root cause analysis when diagnosing issues with database systems.
- Communicated with data architects, programmers and engineers to keep projects on track.
- Provided support for complex issues related to software tools, applications and databases.
- Worked with software vendors to analyze and resolve software installation and ongoing support issues.
- Collaborated with project teams on developing solutions that integrate SQL Server databases into larger architectures.
- Established security controls to help protect client systems.
Technical Lead( SQL DBA)
Cognizant Technology Solutions(CTS)
Kolkata, West Bengal
08.2016 - 08.2017
- Collaborated with project teams on developing solutions that integrate SQL Server databases into larger architectures.
- Solved complex analytical problems using statistical models from data.
- Developed and implemented security initiatives to protect important company data.
- Configured security settings to protect against malicious activities such as unauthorized access or data tampering.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Developed and implemented strategies to ensure data integrity, reliability, and availability.
- Created and monitored performance metrics to keep databases functioning at optimal capacity.
- Reviewed query execution plans to identify inefficient code or recommend index changes for improved performance.
Education
XIIth - Science
Central Board of Secondary Education
01.2007
Bachelor of Science - Information Technology
BPUT
07-2012
Xth - Science
ICSE
01.2005
Skills
- Azure devops
- Container, Teraform
- Microsoft SQL Server 2016 2012/2014 Database Services
- Analysis Services - SSAS
- Reporting Services - SSRS
- Intergration Services – SSIS
- Postgresql
- Linux Server
- Direct Server Support
- Script Maintenance and Updates
- Continuous Integration Systems
- Amazon Web Services
- Data Storage and Retrieval
- Databases: Oracle, MongoDB
- Technical Analysis
- Process Improvement
- Software Development Tools: JIRA, Confluence
- Creative and Innovative
- Cross-Functional Collaboration
- Scrum
- SDLC Processes
- Cybersecurity Analysis
- Database Management Software
- Linux Environments
- SQL Expert
- Continuous Process Improvement
- Linux Operating System
- Disaster Recovery
- Database Management
- Microsoft SQL
- Database Analysis
- Data Testing
- Process Automation
- Root Cause Analysis
- Agile Methodology
Database Development
- Creating Database, Schemas, Snap shots
- Planning, creating and Optimizing Indexes in SQL Server
- Creating, Managing & Optimizing Performance for Views, Procedure, Triggers, Table & Functions
- Query Performance Optimization - Execution Plans, Exception Handling
Integration Services
- Installing and Configuring Integration Services on Clustered Environment for High Availability
- Troubleshooting and Optimizing SSIS package performance
- Deployed and Scheduled DTS | SSIS Packages
Reporting Services
- Installing and Configuring Reporting Services on Clustered Environment for High Availability
- Created basic Reports to meet Ad hoc business requirement
- Publishing / Deploying Report on multiple Report Servers
- Managing Shared Data sources and permissions
Devops
MySQL, RDS, DynamoDB, Jenkins, Ansible, Puppet, Azure DevOps
Selected Achievements
- Received client appreciations and performance awards for solving critical issues.
- Certified by GlobalEnglish STEP+.
- Received best trainee award during training in Poornam Info Vision Pvt. Ltd.
Professional Trainings Certifications
- Microsoft Certified professional in SQL Server.
- MCP:766 Marks in Exam:Administrating in microsft sql server 2012/2014
- Certification course of Oracle 10g from NIIT.
- Certification course C++ and Java from Visual Informatics.
- GlobalEnglish STEP+ Certified.
Service Responsibilities
- As a Database Consultant performed various activities not limited to
- Database Services
- SQL Server DBA Production Support
- Implementing and Maintaining Log Shipping | Database| Clustering | Mirroring | Always On HADR
- Install, manage & troubleshoot multi node multisite SQL Server clusters
- SQL Server Virtualization & Consolidation
- SQL Server Setup, Installation, Version Upgrade & Architect Setup
- Design and Implement Database Backup Restore & Disaster Recovery Strategy
- Database Archiving / Partitioning (Horizontal / Vertical)
- Database Professional, Performance Tuning, and Disaster Recovery
- Setting up Base lining and Capacity Planning
- SQL Server Hardware sizing and bottleneck tuning
- Auditing SQL Server Security
- Data Transfer / Transformation
- Plan, Design and Scheduled Database Maintenance & Administrative Tasks
- Configuring Replication / Data Synchronization
- SQL Server Database Monitoring with DDL Triggers | SQL Server Profiler | Event Notifications
- Troubleshooting SQL Server
- Schedule SQL Jobs | SQL Server across multiple Servers
- Performance Tuning – Execution plan, Profiler, Performance Monitor, Extended Events, Data Collector and Resource Governor
- Disaster Recovery
Personal Information
- Pan Number: BNKPM9740H
- Passport Number: L7376746
- Date of Birth: 02/02/89
- Gender: Female
Projects
ansiblekubernetesproduct.IautosysIntegrationTerraformdevopsdevopsdevops
Wells fargo, Wells fargo, Banking financial services, Senior info Security Engineer-AVP, 7, May 2021 - June 2023, AzurTerraform, TFS, Container, Teraform, SQL Server 2016/2014/2012, Working as a DevOps Engineer in wells fargo. I work on deployments in production as well as lower via TFS and now I am also working on containers and teraform IAC (infrastructure as code) tool that has helped us in build, change and version cloud and on prem resources safe and efficiently across all environments. I also worautosysnitoring jobs on sql server agent and autosys and troubleshooting failures. I am also working on SSRS, SSIS and work on managing permissions and access. I work on working closely with developers and other teams to oversee the code releases for SQL as well as websites which even includes maintenance and updadevopswell. We as devops do monitor the feedback and responses of the users to new releases of a prokuberansibleeldevopsainted with devops tools like GIT, Jenkins, kubernetes, ansible, splunk. I am also working on azure cloud here in wells fargo. I am also working in migrating the on premise SSRS reports to AZURE cloud with developers. I am supporting multiple applications. We have Incident queue to monitor on everyday basis. I work in password updates for service accounts on regular basis because we are responsible for maintaining the security and make the security accounts on regular basis because we are responsible for maintaining the security and make the environment secure for the customers. I work on monitoring Incidents as well creating and scheduling change requests for deployments via ServiceNow. Worked closely with the technical and support teams to deliver and manage services with high uptime Advocate for automated processes to improve quality, deployment, and support of multiple products Build and maintain solutions and tools for automated builds, deployment, monitoring, and operations. Troubleshoot, perform root cause analysis, and implement fixes for deployment and infrastructure issues. Builds new environments and updates existing environments through use of automation. I am well versed in teraform. Maintain cloud infrastructure for multiple products and services. Infrastructure as code design, deployment and maintenance. ADC(Tata Consultancy Services), Avery Dennison Corporation, Manufacturing, IT Analyst (Cloud Engineer), 6, May 2019 - Till date, SQL Server 2016/2014/2012, Postgress SQL, MySQL, AWS, Working on SQL performance issues-optimization. Working on SQL upgrades, working on maintenance activities like trimdb rebuild(postgresql) index rebuild(SQL). Working on tools Like Zabbix, Commvault, BPPM. Working on Database refresh activities. Working on postgresql-maintenenace activities, scripts deployment. Working on automation via jobs and powershell. Cloud Services: Implemented fully automated continuous delivery process. Involving AWS CodePipeline to complete the automation from commit to deployments. Automated Process for creating infrastructure environment for DEV, QA, PERF, PREPROD & PROD using AWS Cloudformation. Automated process of installing CMS Pimcore on all the environment. Creation of lambda function using node.js. Automated the process of creation and deployment of lambda based services. Created Buildscript for deployment. Monitoring service using aws cloudwatch. Created and automated alarms for Production environment at service level. Applied SSL/TCP certificate on Loadbalancer to acknowledge PCI rules. Implemented Cloudfront and S3 to render error page. Created MFA authentication for IAM users. Created Roles and policies to access services and for cross account access. Requirement gathering and providing solution for Optimization of resources. Created Read Replica and Multi A-Z for AWS RDS (MySQL). Configured Amazon Route53 to register domain name, route internet traffic to the domain and to check the health of the AWS resources. Created stack of resources using AWS CloudFormation. Monitoring of EC2 using AWS Cloud Watch. Storing the code in Git Repository. Creation of VPC, Public & Private Subnets, Configure Route tables (default & custom), Network ACL & Security Groups, NAT instances, Internet Gateways, Elastic Load balancer, AutoScaling, EC2. Creation of cloudfront. Pushing code to GIT repository. Creation of IAM users and Roles. Encryption of data in S3 using Key management service. Lifecycle management of S3. Creation of Bash scripts for installation and running of application. AWS CLI commands to perform task on AWS resources. Created snapshot for the EC2 instance volume. Created notification service on email for each code commit. TDC(Tata Consultancy Services), TDC, Telecommunication, IT Analyst (SQLDBA), 7, August 2017 - October 2018, SQL Server 2016, SSIS, SQL server upgrade project, Automation, maintenance activities, successful cutovers, Worked on SQL server upgrade project. Upgraded all the servers from 2000/2005 version to 2016 version or 2014. Done successful cutover after all upgrades. Worked on automation through jobs, powershell. Worked on maintenance activities like patching, index rebuilding. Worked on deployments. Worked on performance issues and optimization. Worked on High availability-by use of log shipping, clustering database mirroring. CITI GLR(Cognizant Technology Solutions), CItIbank, BFS, Technical Lead (SQL DBA), 10, August 2016 - August 2017, SQL SERVER: SQL server 2012/2014, DBCC and DMV, Indexing, create New Job, Database clustering, Archive table, monthly maintenance, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Application Testing: FEMA 3.4 version, Transferring the data (ETL) by SSIS. Rebuilding the indexes at regular intervals for better performance. Automation of daily reports. Generating custom reports. Involved in DBA activities like maintenance of servers. Monitored and modified Performance using execution plans and Index tuning. Involved in manual testing of file event management application (FEMA 3.5 version). Deploying packages through jobs in production. Automation of reports through SSIS. Created maintenance plan for database. Creating stored procedure. Auditing-Identifying the users accessing, updating or deleting data. Backup and recovery: Making periodic backup & recovery plan. Change Management, SQL Server configuration, database schema perform impact analysis before change made in database. Implement changes and then test them. Developing and maintaining best practices. High availability-by use of log shipping, clustering database mirroring. Patching, upgrading SQL instances. Managing SQL based UI application. Managing test environments. Performance tuning- reindexing/reorganizing of indexes. Securities- assigning permissions, creating SQL server login IDs. Scripting- Writing transact SQL scripts for monitoring maintenance task.
Accomplishments
- Received client appreciations and performance awards for solving critical issues.
- Certified by GlobalEnglish STEP+.
- Received best trainee award during training in Poornam Info Vision Pvt. Ltd.
Certification
- Microsoft Certified professional in SQL Server.
- MCP:766 Marks in Exam:Administrating in microsft sql server 2012/2014
- Certification course of Oracle 10g from NIIT.
- Certificationcourse C++ and Java from Visual Informatics.
- GlobalEnglish STEP+ Certified.
Languages
English
Full Professional
Timeline
Senior Info Security Engineer-AVP
Wells Fargo
05.2020 - 06.2023
Cloud Migration and Impl. Senior Analyst
Accenture
01.2020 - 04.2020
SQL Server Database Administrator
Tata Consultancy Services
08.2017 - 01.2020
Technical Lead( SQL DBA)
Cognizant Technology Solutions(CTS)
08.2016 - 08.2017
XIIth - Science
Central Board of Secondary Education
Bachelor of Science - Information Technology
BPUT
Xth - Science
ICSE
Similar Profiles
Laxmikanth ChittampallyLaxmikanth Chittampally
Senior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells FargoSenior Operational Processor at Wells Fargo India Solution PVT Ltd, Wells Fargo
Mayank OberoiMayank Oberoi
Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)Financial Accounting Associate/ Alteryx SME at Wells Fargo International Solutions Private LTD (Wells Fargo)
Kaylah GinyardKaylah Ginyard
Personal Banker at Wells FargoPersonal Banker at Wells Fargo
Daniel Avalos LaraDaniel Avalos Lara
Bank Teller at Wells FargoBank Teller at Wells Fargo
Charles RocheCharles Roche
Firefighter/EMT-Basic at Westborough Fire DepartmentFirefighter/EMT-Basic at Westborough Fire Department