| Murali B - Sr. SQL Server DBA [Skills - SharePoint,SSIS,Dynatrace] - 10+ years Exp - H1B- TX at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1671615&uid= CEIPAL ATS - Simplified Recruiting and Staffing Murali B - Sr. SQL Server DBA [Skills - SharePoint,SSIS,Dynatrace] - 10+ years Exp - H1B - TX Consultant's Details: Consultant Name: Murali B Employer Details: Employer:Nextgen Technologies Inc Contact Person:Kushal Email:[email protected] Note: Please call between 09:30 AM PST to 06:00 PM PST Phone: 4134240484 Murali's Resume Over 10 plus Years of Experience in MS SQL Server, SSIS, SSRS, Power BI, SQL database Administration, DBA Support . Strong Knowledge in all phases of Software Development Lifecycle (SDLC) and design through programming, documentation, project management, configuration management, installation, and implementation. Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments. Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. Comprehensive knowledge and experience in process improvement, normalization/denormalization, data extraction, data cleansing, data manipulation. Expertise in Database design and development of applications using MS SQL Server 2008/2012/2016/2019 Integration Services (SSIS), Reporting Services (SSRS) Experience in Index Maintenance, Index tuning, Rebuild Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics. Performed Query Optimization to increase the performance by tuning SQL queries using Profiler and Execution Plans Implementation of Active Directory SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various categories of users. Experience in High Availability like Replication, Log Shipping, Mirroring and Always on. Implemented database backup and recovery strategies, including point-in-time restores and disaster recovery plans, to ensure data integrity and business continuity. Experience in Creating Jobs, Alerts, and schedule SSIS Packages. Scheduling the Reports Weekly and Monthly basis as per business needs. Having experience in developing and monitoring SSIS Packages. Maintaining the Log and Audit information in the SQL tables and Text files. Jobs monitoring and finding the issues with the help of SQL logs. Experience with T-SQL in Stored Procedures, Views, indexes. Experience in Import/Move data from Production to UAT & QA databases. Having experience in configuring Virtual machines using Azure portal. Having experience in Migrating on Premises SQL Databases to SQL Azure using DMA & DMS (Offline & Online). Having good experience in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer. Experience in the process of Incident/Change/Problem management. Experience in client project support, minimizing service outages, supervise, and produce documentation for issue tracking. TECHNICAL SKILLS SET Operating System Microsoft Windows, Linux Database SQL SERVER 2012/2016/2019/2022, PostgreSQL ETL Tools Visualization Tools Version Controls Ticketing Tool Performance Monitoring Tool SQL SERVER Integration Services. SQL SERVER Reporting Services, Power BI. TFS 2016,2019, GitHub Service Now, Jira Dynatrace, Windows PerfMON, SQL Profiler, Solar winds, AGDiag. PROFESSIOANL EXPERIENCE Title: CDRS Dec 2023 Till date SQL BI Developer / DBA Created Database Objects Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles. Developed complex Stored Procedures using SQL, Dynamic SQL queries having good performance. Extensively used Joins, CTEs, Table Variables, Global and Local Temp Tables. Developed complex SSIS packages to load the data from SQL Server, Oracle databases. Used various transforms in SSIS to load data from at les and FTP to the SQL databases. Designed and developed data load jobs using SSIS package and scheduled in SQL Agent. Worked on migration of SSIS packages in 2008 to 2012. Involved in day-to-day maintenance of database Objects, SSIS packages and SSRS Reports. Provided Index tuning as required for performance improvement of the applications SQL tuning . Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan. Created SSIS packages to validate, extract, transform and load data to data warehouse databases and data mart databases Created and maintained logins, roles and permissions on the SQL instances and databases and provided required privileges according to the user's requirements. Worked with T-SQL, DBCC, DCL, DDL, DML Scripts and established relationships between tables using Constraints. Designed, tested unit testing and integration testing and implemented stored procedures and triggers for data processing of huge volume of data. Environment : Windows 11, SQL Server BIDS, SSMS 2016/19, Postgresql, Visual Studio 2012/2016, Dynatrace, solar winds, SSRS 2016 SharePoint and Microsoft Excel, Service Now, Azure SQL Database, Erwin 7.1, Power BI. Title: Jonah Energy Jan 2023 Nov 2023 SQL BI/DBA Upgraded/Migrated SQL Server Instances/Databases from older version SQL Server to new version of SQL Server Developed SSIS Packages from different sources like SQL Server Database, Flat file, CSV, Excel and many other data sources supports ODBC, OLE DB Data Sources Experience in Maintaining SQL Server Security, creation of Active Directory groups logins and users, configuring permissions and assigning roles to users. Deployed SSIS packages to move data across server, move logins, load data from different data Sources Expert in interpreting execution plans and identifying query optimization opportunities. Leveraged execution plan analysis to make informed decisions on index creation, statistics updates, and query rewrites. Extensively work with SQL Profiler, Activity monitor, DMVs, DMFs and DTA to tune the databases, queries, performance related issues like memory CPU and I/O issues Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, Notifications Implemented SQL Server high availability technologies such as Always On and log shipping to ensure maximum uptime for critical applications. Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check) Environment : Windows 11, SQL Server BIDS, SSMS 2016/19, Postgresql, Visual Studio 2012/2016, Dynatrace, solar winds, SSRS 2016 SharePoint and Microsoft Excel, Service Now, Azure SQL Database, Erwin 7.1, Power BI. Title: CMT (Clinical Management Tool) Jan 2022 Jan 2023 SQL BI/ DBA Consultant Developed normalized Logical and Physical database models to design OLTP system. Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Mode. Created Tables, stored procedures, Views, and Triggers Scheduled many jobs to automate different database related activities including backup, Successfully optimized SQL Server databases to enhance query performance and reduce response times. Implemented strategies to improve overall database performance, resulting in a noticeable increase in system efficiency. monitoring database health, disk space, backup verification Developed Different Maintenance Plans for database monitoring Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, notifications Create and managed different types of Indexes (Cluster/Non-Cluster), Constraints (Unique/Check) Experience in AlwaysOn environment Performed database and SQL/TSQL Performance Tuning Environment : Windows 11, SQL Server BIDS, SSMS 2016/19, Visual Studio 2012/2016, Dynatrace, SSRS 2016 SharePoint and Microsoft Excel, Service Now, Azure SQL Database, Erwin 7.1, Power BI. Title : BART (Biomed Application for Repair Tracking). Dec 2019 Dec 2021 Senior Developer/DBA Analyst Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions. Written and executed complex T-SQL queries using SQL Server Management Studio for back-end data validation testing. Monitoring Daily backup jobs and automation of daily restores of development databases. Monitoring the Disk Space of all the Servers. Configuring and Monitoring log shipping and Database mirroring on Disaster recovery Servers. Database snapshot creation for the synchronized databases for Reporting Purposes. Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server Developed user defined Healthcare reports to provide on demand Healthcare data analysis using SSRS Performed data conversions from flat files into a normalized database structure Developed numerous ad-hoc reports using SSRS for day-to-day financial reporting. Coordinated with UI team to resolve the problems. Report the application related issues to the respective team. Environment : Windows 10, SQL Server BIDS, SSMS 2016/19, Visual Studio 2012/2016, Dynatrace, SSRS 2016 SharePoint and Microsoft Excel. Title : Jaguar-Pmx Johnson & Johnson, Bangalore, India Sep 2016 Dec 2019 Senior Developer Created Event Handlers and log providers for tracking errors and maintaining logs for recording package execution status. Created Configurations to change the package properties dynamically. Moving data from JIRA database to staging database on daily basis. Generating the feed files from SSIS package and moving it to Cloudera using Winscp. Migrating data from one server to another server using SQL\\SSIS Creating SSIS packages and scheduling jobs Actively monitoring the SQL jobs and sending the status on daily basis to team. Will Run the reports on weekly basis and share the status of the projects to clients Environment : Windows 10, SQL Server BIDS, SSMS 2016/19, Visual Studio 2012/2016, Dynatrace, SSRS 2016 SharePoint and Microsoft Excel, Postgresql, JIRA, CloudEra. Title : Health Management Corporation (HMC) - HRS Anthem Inc, Chennai, India Jul 2013 Sep 2016 SQL Developer/ Analyst Importing Source/Target tables from the respective databases by using Execute SQL Task using Control Tasks in SQL Server 2008 Integration services. Extracting data from SQL Server, transforming, cleansing, validating data and loading into Destination for fulfilment process. Report the application related issues to the respective support teams. Communicating with the end users and business to fix the issues in Production using SQL server database Responsible for SLA delivery, client interface and resolving complex technical problems. Actively participating in team meeting to discuss and analyses production issues. Actively coordinating with developers team to fix any issues related to application support Analysed and fixed the issues from backend like eligibility issues, Alerts, Goals and letters Through CQ s and CR s in HRS as a Lights on Support. Grant and deny access for the users to HRS application. Provided 24/7 application support based on shifts and handled on call activities. Environment : Windows 10, SQL Server BIDS, SSMS 2016/19, Visual Studio 2012/2016, Dynatrace, SSRS 2016 SharePoint and Microsoft Excel, IBM Tivoli EDUCATIONAL CREDENTIALS B. Tech (INFORMATION TECHNOLOGY)- 2010 JNTU, Hyderabad, India. Note: Please call between 09:30 AM PST to 06:00 PM PST Kushal | 1735 N 1St ST., Suite 308 |San Jose, CA 95112 NextGen Technologies Inc Email: [email protected]. Website: www.nextgentechinc.com | 4134240484 | Keywords: quality analyst user interface access management business intelligence database active directory information technology microsoft California Texas Murali B - Sr. SQL Server DBA [Skills - SharePoint,SSIS,Dynatrace] - 10+ years Exp - H1B- TX [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1671615&uid= |
| [email protected] View All |
| 10:54 PM 19-Aug-24 |
| Attached File(s): Murali_Sql_DB_1724088279918.doc Please check the file(s) for viruses. Files are checked manually and then made available for download. |