| Murali B - Sr. SQL BI/DBA - 10+ years Exp - H1B- TX at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1463177&uid= CEIPAL ATS - Simplified Recruiting and Staffing Murali B - Sr. SQL BI/DBA - 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+ Years of Experience in MS SQL Server, SSIS, SSRS, Power BI, SQL Aatabase 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). Extensive experience in Migration from Oracle to SQL. 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 SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various categories of users. Experience in database backup and recovery strategies. Extensively worked on Siebel EIM and creating procedures, End to End data migration implementation in Siebel. Experience in Creating Jobs, Alerts, and schedule SSIS Packages. Experience in migrating legacy applications from VB ASP to C .NET/VB.NET ASP.NET 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 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 installation of Oracle 10G and Unix scripting. Experience in client project support, minimizing service outages, supervising, and produce documentation for issue tracking. TECHNICAL SKILLS SET Operating System Microsoft Windows, Linux Database SQL SERVER 2012/2016/2019, Oracle 9i/11g ETL Tools Visualization Tools Version Controls Ticketing Tool Performance Monitoring Tools 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 Role: Sr. SQL BI/DBA 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. Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle. Design new SSIS packages as per needs, Resolve the problems. Created Tables, stored procedures, Views. Created numerous SSIS Packages for transferring and manipulating data from existing SQL databases, Oracle data sources, flat files, access DBs and excel files using various connections, tasks, Global Variables Incorporating business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server. Creating new database/tables to put in the extracted data and rebuilding the relationship. Core feature development in .NET 4.0 4.5 with ASP.NET C SQL Server 2012. 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 Deployed SSIS packages to move data across server, move logins, load data from different data sources 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) Developed various types of complex reports like Drill Down, Drill through, Cross tab reports. Environment : Windows 11, SQL Server BIDS, SSMS 2016/19, Visual Studio 2012/2016, Dynatrace, Oracle, solar winds, SSRS 2016 and Microsoft Excel, Service Now, Azure SQL Database, Erwin 7.1, Power BI. Title: CMT (Clinical Management Tool) Role: SQL BI/ DBA Consultant 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. Extensively worked and had good knowledge on Integration and Reporting services and good experience in data migration from Oracle/Access/Excel sheets to SQL Server 2005/2000/7.0. Developed the front end using ASP.Net HTML and CSS. Scheduled many jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification Developed Different Maintenance Plans for database monitoring. Application support for front end feeds and Resolved Application connectivity issues like connection timeouts, connection pooling issues and memory leaks. Managed and maintained SQL Server databases with a focus on data security and compliance. Setup Jobs, Maintenance plans for backups, Rebuilding indexes, check server health, alert, Notifications. Experience in Always On environment. Created SSIS packages to export data from Oracle to SQL Server Database. Created SSIS / DTS packages to pull data from Oracle, Access, and Flat Files. Performed database and SQL/TSQL Performance Tuning. Participated in on-call rotation for database-related emergencies and provided timely support. Environment : Windows 11, SQL Server BIDS, SSMS 2016/19, Oracle, 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). Role: 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. Worked on SSIS packages to import the data from Oracle, Access, and text files. 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. Environment : Windows 10, SQL Server BIDS, SSMS 2016/19, Visual Studio 2012/2016, Dynatrace, SSRS 2016 and Microsoft Excel. Title: Jaguar- Pmx Sep 2016 Dec 2019 Role: 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, Cloud Era. Title: Health Management Corporation (HMC) - HRS Jul 2013 Sep 2016 Role: 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. Analysed and fixed the issues from backend like eligibility issues, Alerts, Goals, and letters. Through CQs and CRs 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 , 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: cprogramm quality analyst access management business intelligence database active directory information technology microsoft California Texas Murali B - Sr. SQL BI/DBA - 10+ years Exp - H1B- TX [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1463177&uid= |
| [email protected] View All |
| 09:52 PM 07-Jun-24 |
| Attached File(s): Murali B_1717777369226.doc Please check the file(s) for viruses. Files are checked manually and then made available for download. |