Home

Rajesh - SQL DBA

[email protected]

Location: Dallas, Texas, USA

Relocation:

Visa: H1B

Summary: 10 years of IT experience in Database administration/Analysis/Developing, maintenance, performance tuning, security, patching and upgrades in SQL Server and Oracle. Experience in Database Administration On-Premise and Azure cloud and development for very large and complex Databases in Microsoft SQL Server 2019/2017/2016/2014/2012/2008 R/ 2000 in Development, Test, UAT and Production Environments. experience in Installations, Configuration, Designing, Security, Deployment, Backup, Performance Tuning, Upgrades, Patching of Software on Systems like ORACLE, PostgreSQL, SQL Server, Oracle EBS configured on different platforms Linux, Unix. Provided 24x7 on-call support for Oracle and SQL Server database servers and DevOps. Experience in upgrading databases to newer versions of SQL Server and Oracle. Worked extensively on implementing Backup Recovery and Point in Time Recovery Strategies. Proficient in SQL Server 2005/2008/2008R2/2012/2014/2017 and oracle 11g, 12c. Experience in consolidating databases to shared servers to reduce the licensing costs. Experience in implementing High Availability solutions like Data Mirroring, Log Shipping, Replication, Always on Availability Groups and Clustering. Strong Experience in generating reports using Power BI, SSRS and Splunk. Used tools like SQL* Loader, OEM, TOAD, SQL Management Studio, Service Now. Expertise in Debugging, Error logging, Error Handling and Production support. Configured Data guard Database for Disaster Recovery. Migrated Data using Data Pump Utility, SQL Loader and Transportable table space. Knowledge and experience in designing, developing and deploying Reports and Dashboards. Tuned SQL at application, Instance and database using Explain Plans and Hints, to better performance. Worked on large scale database environment OLTP and OLAP systems. Results oriented and persistence to solve problems. Good team player, interpersonal and communication skills combined with self-motivation and the ability to think outside the box. Education: Bachelor of Engineering in Mechanical Engineering, INDIA Technical Skills Summary: Software Tools: Store Procedures, Service Now, Rman, Shell scripting Databases: SQL Server, Document Direct, Oracle Technologies: SQL, Oracle, Pl/SQL, Solaris, PostgreSQL, SQLMI, Attunity Methodologies: Software Development Methodology (SDM), Rational Unified Process (RUP), Agile (Scrum) Testing Tools: iServe, Jira, Visual Studio Document management tools: MS SharePoint, MS Team Foundation Server, MS Office apps, Notepad Requirements Management tools: Jira Virtualization tools/ Environments: RAC, Delphix Data Warehousing: MS Access, SQL Server, Data Lake, Oracle DBA Database Query tools used: TOAD, SQL server, Advanced Query Tool Other Google Analytics, Linux, Unix Functional: Healthcare/Insurance domain Skills. Business Analysis of Healthcare and Insurance domain. Experience in Privacy and Security aspects of HIPAA Regulation. Work Experience: SQL/Azure Database Administrator June 19-Present Molina Health Care, Long Beach, CA Responsibilities: Install SQL Server 2017 Standard and Enterprise Editions on Windows 2012 and 2016 Servers. Set up and create maintenance tasks for backups, rebuild indexes, reorganize indexes and update statistics. Install and setup Report Server configuration for SSRS reports on standalone SQL Servers. Implementing Backup and Recovery strategies and supporting Delphix Database Virtualization Platform. Creating DSources from the production database on Prod Delphix engine, creating VDBs from them and replicating to non-prod by using Delphix Replication. Creating Delphix Masked VDBs from them for end clients. Experience in SQL Server 2016 new features like Query Store, IN memory OLTP and Database stretching to Azure platform. Configuring Azure services PaaS/IaaS and migrated database from On-Premise to Azure. Experience in creating and maintaining Azure SQL databases using the right tiers. Migrated On-Premise SQL databases to Azure Portal. Monitored Azure databases on weekly basis to cut costs on DTU basis. Monitor and resolve Change requests and Incident tickets as per the SLA provided by the client. Implement, maintain, and test database backup & recovery strategies. Configure and monitor Always-On Availability Groups and Database Recovery plan, Implement and participated in Disaster Recovery Drill processes. Troubleshoot blockings, deadlocks using blocker scripts, trace flags and activity monitor. Migrate Servers from SQL Server 2014 to the new SQL Server 2017 Azure as part of side-by- side server migration. Upgrade the database servers of around 50 applications in upgrade project from 2008 to 2017. Monitoring the SQL Server Agent jobs, alerts and long running Queries. Encrypt data and log files using Vormetric Encryption tool and prepare documentation. for the Disaster Recovery plan. Implement new SQL features like Row and Page compression mechanism, CDC, Data Compression, Backup compression, Resource Governor and Performance Data Collector. Implemented Attunity tasks on reporting servers for Prod sensitive data for high visibility projects, needed for testing. Tuned slow running queries using Profiler and Statistics IO by using different methods in terms of evaluating joins, indexes, updating Statistics and code modifications. Checking Database Health by using DBCC Commands and Dynamic Management Views. Review and monitor system and instance resources to insure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention). Molina Health Care, Long Beach, CA Dec 18 May 19 MSBI Support Engineer/DBA Responsibilities: Report design/tuning /troubleshooting to provide operational support for the 40+ self-service reporting teams are adopting and migrating to latest platform. support report solutions and implementing data security designs as well as performance tuning and monitoring. Perform installing, monitoring, migrating/deploying, performance tuning, securing report servers, interfacing to data sources. Performance tuning and monitoring support to keep up the centralized reporting environment optimally. Relevant database/warehouse knowledge from a BI reporting aspect. Ability to understand and support reporting solutions connected to various databases and warehouse platforms. Designing/developing reporting solutions as well as administering/supporting centralized reporting environments with large user base. Understanding domain specific data sets, implementing /enforcing /follow HIPAA regulations, PHI and data security/privacy other governance best practices. DBA supporting three major projects from Development to Production via Test environments, involving daily administration of Databases running on Red Hat Linux 5.3 and MS SQL Server with Database sizes range from 600 GB to 14TB in (OLTP& OLAP environments). Performed day to day activities like resolving Tickets for multiple environments. Create database Objects, Tablespaces, Schemas as needed. Refresh data from Production to Test as needed. Automate Backup/Restoration Strategy, Scheduling Backups, taking Logical Backups (with Export/Import, Data pump utilities). Worked on database security management, monitoring methods and provided technical support to all application administrators and users. Managed Cloud environments executing tasks in client end and hosting datacenter. Applied new relies patch to databases and application servers using Opatch utility. Performed SQL and PL/SQL tuning and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM), Active Session History (ASH) and Explain Plan. Worked closely with developers for the better performance with Applications in debugging Packages, Triggers and Indexes on the tables. Developed scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space. Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Statistics. Generated Reports from SQL Trace, Explain Plan, AWR, ADDM to analyze the database performance on daily basis. Understand, clarify/advise on user support requirements and communicate incidents and best practices governance practices. Communicating effectively with various self-service report development teams in configuring, deploying, troubleshooting/tuning, operations support activities. Customized sites on SharePoint Portal and hosted the SSRS and Power Pivot reports on to SharePoint. Eli Lilly, Indianapolis, IN Sep 17 Nov 18 SQL DBA Responsibilities: Responsible for scheduled job maintenance and trouble shooting. Maintained database for inventory, billing and invoice systems and created dynamic stored procedures to retrieve the customer details, payment history by giving related parameters. Used Agile Development Methodology. Point of contact for all the production issues. Ensured that Database systems operate securely and efficiently. Install new releases patch to associated database management production software. Generate Explain plan, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports, to analyze databases. Provided 24X7support for all the production and development databases. Implemented data refreshes (at database, schema & table level). Monitor the performance of the Databases and view Alert log files and Trace files. Worked extensively with Physical Standby database, troubleshooting technical issues. Served as DBA or project lead in the completion of 80+ medium- to large-scale implementations, managing projects from business requirements analysis to solutions delivery and support. Ensure newly created environments and the existing environments are HIPAA compliant. Create backup and DR strategies for all new and existing systems (Always ON Availability Groups) Developed and tested storage strategies and disaster-recovery plan for large manufacturing company s operational database, delivering solution that guaranteed recovery performance and high availability. Enhanced users understanding of database systems by conducting pre-implementation workshops, delivering group and individual training sessions and creating user-friendly training materials. Arconic, Pasadena, CA Oct 16 - Aug 17 MS SQL DBA Responsibilities: Maintain, Monitor and tune over 75 SQL Servers in Production environment and 250 in other environments. Provide 24/7 support on a weekly shift basis. Installation and configuration of SQL Server 2012 as per business rules. Configuring and supporting Always ON Clusters. Migration of databases between different versions of SQL Server. Capacity planning of new servers. Monitor space on a daily basis to ensure that it's not crossed the business specific threshold. Provide review of SQL Server Environment for auditing. Assist fellow DBAs and developers in day to day issues and queries. Configured third party tool Insight, in order to remotely monitor all SQL, Oracle and Sybase production environments. Created Linked servers as and when requested. Initiated, organize and participate in BCP testing and documentation. Configure and maintain Database mirroring in order to create a DR environment. Involved in time-saving, robust employee data-intake system that automated database update functions, enabling new salary and process-exception information to be automatically populated. Wells Fargo, MN Aug 15 - Sep 16 SQL Server DBA Responsibilities: Analyzed the project database requirements from the user. Maintain and monitor about 20 SQL Servers (Versions 2008/2008 R2/2012/2014). Patch Management Process Quarterly review of all applications and servers for patching. Created various Tables and Views as per business requirements because of access issues on app team side. Migrated data from SQL Server to Oracle. Verify backups and error logs on the servers and troubleshot any failure or alerts. Responding and resolved everyday issues and requests, if required to work with other team members from other departments. Environment: MS SQL Server 2014/12 Enterprise Edition, Integration Services 2012, Windows XP Professional. Renault, Hyderabad, India Nov 14 - July 15 SQL Developer Responsibilities: Experience in systems, Requirements Analysis, applications, and Application Development. Experience in Implementation of Production Environment Hardware requirements like Data Loading with SQL Loader. Worked extensively on Tuning SQL and PL/SQL Programs and implementation in Writing DB Procedures. Implementation of Execute Modules, Code Review. Exposure to Coding, Unit testing & Write test cases. Experience in using effectively Exporting and Importing Utilities. Very good experience in the Development and Database Optimization. Experience on working with SHELL Script for launching the Batch. Environment: Windows 8, SQL Server 2012, Oracle11g, Oracle10g, PL/SQL, Management Studio, SQL Profiler, SQL Query Analyzer, HPQC, UNIX, Enterprise Manager. IHS Technology, Hyderabad, India June 13 Oct 14 SQL Data Analyst Responsibilities: Accurately identifying, extracting, and analyzing large volumes of data. Extracting data from databases and cleansing, transforming, and integrating it. Creating stored procedures for reporting/processing data. Executing manual processes and automating where feasible. Working with business units to coordinate data scope and format requirements. Documenting existing processes. Providing production support for bug fixes and enhancements. Defining, in written form, data and reporting requirements for new projects obtained from business and technical leads. Developing and testing Excel macros using VBA for reports and transferring data using DTS package. Collaborating with various levels of staff including senior management on numerous reporting initiatives. Environment: MS SQL Server 2008, Management Studio, Visual Basic 6.0 and Excel. Keywords: business intelligence database rlang information technology microsoft procedural language California Minnesota