Usha Rani G
Broomfield,USA
Summary
Results-driven Sr. Manager with extensive experience at OpenText Corporation, specializing in MySQL and SQL Server administration. Achieved 99.99% database uptime through performance enhancements and strategic optimizations. Expertise in automation and scripting, facilitating effective collaboration between technical and non-technical teams.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Sr. Manager, Database Administrator
OpenText Corporation
Broomfield, CO
10.2014 - Current
- Drove comprehensive data vision covering infrastructure, governance, analytics, and applied machine learning.
- Leveraged generative AI techniques emphasizing deep learning to extract actionable insights.
- Scaled modern data architecture using Snowflake, Airflow, Kafka, and Looker for robust data pipelines.
- Collaborated with product, engineering, security, and compliance teams to fulfill data requirements.
- Established best practices in data quality, observability, security, access control, and regulatory compliance.
- Partnered with leadership to formulate data-informed strategies and predictive models for growth.
- Led recruitment and development of a high-performing data team to foster innovation.
- Monitored database performance while ensuring compliance with security protocols and regulations.
Lead Database Administrator
CHI - Catholic Health Initiatives
Englewood, CO
03.2013 - 10.2014
- Lead Database Administrator (DBA) is responsible for providing technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the company.
- Monitoring of database size and disk space in Production, Staging & Development environments.
- Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
- Performed installation of SQL Enterprise 2005 64bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
- Failover cluster testing and resolution on HP servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
- Configured Transactional Replication and Log Shipping with SQL Server Management Studio as well as basic account management and troubleshooting with connectivity, security and firewall issues.
- Conducted Performance Tuning using SQL Profiler and Windows Performance Monitor.
- Configured Database mail, linked servers in SQL server 2005.
- Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration.
- Scripting development and troubleshooting for various security syncing scripts to new databases as well as creation of database roles for granting Stored Procedure rights.
- Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
- Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
- Troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention.
- Configuring and Maintaining backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
Support Engineer
Microsoft Corporation
India
10.2008 - 03.2013
- Company Overview: Microsoft Corporation is a multinational technology company that develops, manufactures, licenses, supports, and sells computer software, consumer electronics, personal computers, and services.
- Maintaining and managing servers owned by the team. These servers are Windows 2003 (IIS Servers), Windows 2008 (IIS Servers), SQL Server 2005, 2008 and 2012. Supporting Pre-Production and Production environment with 30+ various applications.
- Providing Tire 3 production and pre-production support for 24x5.
- Maintenance of Production and pre-production servers and responsible for day to day activities for smooth running of all applications.
- Working on Tire 3 and Tire 2 tickets through https://mse/en ticket tracking tool.
- Taking care of RCA (root cause analysis) for various issues.
- Participating in deployment of different patches, builds and applications latest versions using various build deployment tools like Octopus, Build Studio. Performing Password reset activity using Password Updater tool.
- Participating in environment refresh activity, application de-commission, servers’ de-commission and server maintenance tasks etc.
- Monitoring and troubleshooting Batch jobs.
- Applying Major Upgrades [Monthly/Quarterly releases] on the Servers and troubleshooting issues faced while installing the patches.
- Upgraded our applications to Always on feature of SQL 2012 version.
- Creation / Replication of the environments on new servers.
- Database auditing, monitoring of various database activities, working proactively on performance issues.
- SQL Server migrations and new server setup.
- Worked on Applications up gradation from IIS 6.0 to 7.0 and 7.5 Create and maintain site collections, web applications and corresponding IIS components, libraries, lists, content types and web parts.
- Supports the daily operations of the SharePoint/Index/Project Server environments and interfaces including code migrations, setup/configuration, operational monitoring, troubleshooting and error handling, performance/tuning, and problem determination and resolution.
- Administration of SharePoint On-Premises and O365 SharePoint Online Platform.
- Designs, configures and optimizes the architecture of SharePoint/Project Server systems, including web, application and database servers.
- Install, configure, and maintain Microsoft software add-ins, third-party tools, and COTS development tools.
- Collaborates with systems analysts, development and functional teams to understand business requirements.
- Perform backups, migrations, and recovery of SharePoint objects using the out of box capabilities.
- Ability to support Microsoft SQL Server Database Maintenance, SharePoint Integration and SSRS Reports development.
- Create standard operating procedures (SOPs) document for system administration tasks.
- Serve as a Subject matter Expert (SME) from a technical perspective supporting members through education mentoring and knowledge sharing of SharePoint technologies.
- Ability to multi task with in tight deadlines.
- Must be customer focused and demonstrate initiative.
- Strong interpersonal skills to work closely with the business team on a day-to-day basis.
- Microsoft Corporation is a multinational technology company that develops, manufactures, licenses, supports, and sells computer software, consumer electronics, personal computers, and services.
Developer - L2
Schneider Electric
US
03.2008 - 09.2008
- Company Overview: Schneider Electric is one of largest energy systems manufactures and provides its product services across the geographies and helps people make the most of their energy. Schneider Electric operates in five markets: Energy & Infrastructure, Industry, Data Centers & Networks, Buildings and Residential. Schneider Electric develops a full range of integrated, smart and inter-communicating solutions to make power safe and reliable, develop automation everywhere, improve energy efficiency, and manage comfort and communication within buildings.
- Analyzing the Request Management raised by the customer, and prepare a Statement of work for the request.
- We have direct interaction with the customer, to understand the requirements and functionality desired by the client.
- Then we develop Technical design Document.
- I have done many code changes on different applications like Quote to Cash, SMS reporter and other.
- Updates the SMTD with all the Business changes.
- Involved in the Unit Testing, Integration testing, System Testing, Regression Testing, Patch Testing of Insight 1.2 application.
- Executed Insight 1.2 application Test cases and raised Critical defects.
- Involved in Test Plan preparation for Insight 1.3 application.
- Designed Test cases for Insight 1.3 application.
- Performed Integration testing, System Testing, Regression testing and Database Testing for Insight 1.3.
- Schneider Electric is one of largest energy systems manufactures and provides its product services across the geographies and helps people make the most of their energy. Schneider Electric operates in five markets: Energy & Infrastructure, Industry, Data Centers & Networks, Buildings and Residential. Schneider Electric develops a full range of integrated, smart and inter-communicating solutions to make power safe and reliable, develop automation everywhere, improve energy efficiency, and manage comfort and communication within buildings.
Developer - L1
ACS Government Healthcare Solutions
US
12.2007 - 02.2008
- Company Overview: ACS is a basic US Health Care insurance platform capability including Policy, Certificate, Claims Administration, Claims Adjudication, Billing and Payment.
- Implemented INTERNATIONALISATION for all the modules of Claim Administration group.
- Developed Business Rules in the Blaze Rules Engine. These were implemented in the JSF tags so that they are triggered through application.
- Also written JUnit Test Cases for the developed Rules in RAD Environment.
- ACS is a basic US Health Care insurance platform capability including Policy, Certificate, Claims Administration, Claims Adjudication, Billing and Payment.
Education
Master's - software engineering
Birla institute of Technology
Skills
- SQL Server, MySQL, and PostgreSQL
- Database administration
- System analysis and design
- Windows and Linux support
- Cloud computing
- High availability solutions
- Replication strategies
- Performance tuning and profiling
- Backup and recovery processes
- Security management
- Automation and scripting
- SharePoint and IIS administration
- PowerShell scripting
- SOX and PCI compliance
- Project management and team leadership
- Clustering techniques
- Database monitoring and data migration
Certification
Microsoft Certified Database Administrator
Timeline
Sr. Manager, Database Administrator
OpenText Corporation
10.2014 - Current
Lead Database Administrator
CHI - Catholic Health Initiatives
03.2013 - 10.2014
Support Engineer
Microsoft Corporation
10.2008 - 03.2013
Developer - L2
Schneider Electric
03.2008 - 09.2008
Developer - L1
ACS Government Healthcare Solutions
12.2007 - 02.2008
Master's - software engineering
Birla institute of Technology
Similar Profiles
Naveen Raj BNaveen Raj B
Senior Technical Writer at OpenText CorporationSenior Technical Writer at OpenText Corporation
TERRA LYNNE NACKETERRA LYNNE NACKE
Manager, Account Development, Enterprise and United States Public Sector at OpenText CorporationManager, Account Development, Enterprise and United States Public Sector at OpenText Corporation
Madhusudhan SMadhusudhan S
Quality Assurance Engineer at OpenText CorporationQuality Assurance Engineer at OpenText Corporation
Anshika MitraAnshika Mitra
Sr. PS Project Manager at OpenText CorporationSr. PS Project Manager at OpenText Corporation
MICHELE BASSANOMICHELE BASSANO
Procurement Analyst at Nutrien Ag SolutionsProcurement Analyst at Nutrien Ag Solutions