Sql Server Manager
Resume:
Sunil B Krishnappa
*************@*****.***
SUMMARY:
IT Professional with 7+ years of experience in SQL Server Database Administration and SQL Server development
Experience in installation, maintenance of different versions of SQL Servers (2016,2014, 2012, 2008R2/2008/2005/2000) in both OLTP and OLAP lower regions and Production environments
Implemented High Availability & Disaster Recovery techniques like Always-ON Availability Groups, Clustering (Active-Active and Active--Passive), Database Mirroring, Transactional Replication and Log Shipping.
Upgraded SQL Server databases from SQL Server 2000/2005 to SQL Server 2008R2/2012/2014/2016.
Hands on experience in working with MSSQL SERVER 2005, 2008 and 2008R2 features and extensive knowledge on SQL 2012/2014/2016 new features.
Expertise in Performance Tuning, Index Tuning, Maintenance, Troubleshooting, Query Optimization, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
Exquisite skills in SSMS-Creating and scheduling jobs, alerts and operators with SQL Server Agent, handling Backup/Recovery of databases, Replication, Linked Servers, and databases Maintenance.
Expert in using Native tools like SQL Server Profiler, Database Tuning Advisor and Perfmon.
Hands-on experience in resolving locks deadlocks, handling Isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
Experience in Physical and logical data modeling using ERWIN & VISIO.
Experience in developing and tuning SQL Server Integration Services (SSIS) packages with (.Net) framework with C# and SSRS reports
Configuring and maintaining Report Manager and Report Server for reporting services.
Experience in planning and implementing Database Security by creating Logins, Users, Roles and assigning permissions according to the requirement.
Handled numerous Change Management requests on production servers Supported 24 X 7 Production on Call.
Learnt and working knowledge on Cloud based environment for SQL Server (AWS).
Documenting procedures in run books.
TECHNICAL SKILLS:
Operating Systems:
Windows Vista/XP/2000/NT, Server 2003, Server 2008/2008 R2, Server 2012, Server 2012 R2, Exchange 2003, Linux, Unix.
Databases:
MS SQL Server 2016/2014/2012/2008 R2/2008/2005/2000/7.0, MS Office Access 97/2000/2003.
ETL & REPORTING Tools:
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)
Database Tools:
SQL Server profiler, SQL Query Analyzer, Database Engine Tuning Advisor, Data Index Analyzer, SQL Server Management Studio.
Third Party Tools:
Idera V5.2\7.1\7.2.2, Companion,lite speed, Red gate, VERITAS NetBackup, Erwin r7, TSM\TDP
Languages:
T-SQL, PowerShell, C/C++, Java, PERL, Visual Studio2005/2003, XML, HTML, Python, ASP.NET, VB.Net.
Applications:
Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.
EDUCATION:
Bachelor of Engineering in Electronics and Communication Engineering, SVCE, India
PROFESSIONAL EXPERIENCE:
XO Group Inc. Jan 2017 – till Date
Austin, Texas
Sr. MSSQL Server DBA
The knot, The Nest, The Bump: Inspire, inform, cheer community as they move towards their life amazing milestone. From proposals to creating home and starting a family together, to be there for every moment of journey.
Responsibilities:
●Managed users and permissions for both SOX-compliant and non-audited database instances.
●Provision of support for developers and end-users when faced with performance issues
●Managed backups and ensured recoverability by testing the restore process periodically
●Performed regular maintenance to ensure reliability and performance for database instances
●Installed and configured new SQL Servers as needed to support business purpose
●Installed, Manage and troubleshoot multi node multi-site SQL Server clusters
●Configuration and troubleshoot Always on involved SQL Server replicas
●Migrated company SharePoint 2010 farm to SharePoint 2013 farm where content databases were stored on Availability databases with secondary allowed to be read
●Deployed database change scripts provided by third party vendors as well as internal support/developers requested through JIRA ticket tool
●Automated Import and export of data via SSIS packages with Data to be filtered as parameters
●Dealt with huge dataset involved data retrieval Performance issue after analyzing database objects like Views, stored procedure and long running queries to go with deep analysis for execution plan of the query and to support with hints to suffice the optimizer to pick the best plan to execute query under concern.
●Troubleshoot of DTS packages and SSIS packages with few tweaks that would enhance the credibility of SSIS packages used
●Suggested huge data set to be queried after partitioning with creating a partition function on period of data for DataMart and Data warehouse (as there would be archived data as well) so they reduce difficulties of dealing with huge data being retrieved for cache by optimizer to hold on usage of server resources for processing the query
●Deployment performed on relational database systems (RDS) for SQL server instances on AWS environments and maintenance of those SQL Server instances as well
●Audit of dormant account was created as a report to track unused account logins to be removed there by reducing security risk across servers
●Experience with supporting related SQL Server Features (Reporting, Integration, and Analysis Services) and developed solutions as necessary for Reporting and Integration Services
●Provide on-call operational support for database systems via PagerDuty to log critical incidents for audit and log issues faced as an Primary contact
●Worked with team for VMWare experience, including building VMs as well as supporting the VM and add storage space
●Learning prospect for MongoDB was provisioned
Environment: MS SQL Server 2005, 2008 R2, 2012,2014, 2016, Windows 2003 Server, Windows 2008/2008 R2, Windows 2012/2012R2 Server, Linux, MS Visual Studio 2010, SSIS Packages, Excel, HTML, AWS, Idera SQL Secure, SQL diagnostic manager, JIRA, PagerDuty, PasswordState.
PepsiCo Inc. [HCL America Inc.] Sep 2016 – Dec 2016
Plano, Texas
MSSQL Server DBA
Branded with thoughts to build entrepreneurs with ideas within themselves as team of HCL came forward to support infrastructure of PepsiCo Inc. and HCL is one of the Top notch company in the field of IT infrastructure globally for supply chain Management, customer relation and Enterprise This is inclusive of marketing sectors India, North America, Russia, Europe, and Middle-East Asian Countries, which is growing with retail and solutions category of Business.
Responsibilities:
●Our inventory is huge consisting of more than 3500 MS SQL servers globally
●Installed, managed and administrated the MS SQL Server 2016/2014/12/08/05 Production and Non Production Servers
●The Customer Loyalty program is developed for Retail Industry. This system automates Customer enrollment, Partner Management, Customer transactions, their Points management, Shipping, Points Bonus and Campaign Management. This system involves an OLTP system and Data Warehouse system for Campaigns
●Mainly worked with Inplace and side by side migration of legacy application SQL Servers.
●Worked with DTS packages to load the massaged data into Data warehousing system.
●The project involved Manufacturing and Logistics solutions with planning and scheduling for stuffing, destuffing, Billing, vendor-managed inventory and warehouse management
●Handled up to 2.5 TB size database in Active Passive clustered Environment.
● Used NetBackup Tool for backups and maintenance jobs which includes updating statistics, database integrity checks
●Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
●Created Logins for the users and manage their permissions.
●Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
●Used Bulk insert to load huge tables.
●Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
●Implemented partitioning on large table to get the performance.
●Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
●Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
●Performed Migrations for almost about 80 PEPSICO Inc. legacy database SQL Server migration from SQL 2000/2005 to SQL Server 2012/2014 databases, after running the server side trace to know about the depreciation factors and announcements
●Extracted data from various sources like SQL Server 2008/2012/2014, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
●Created SSIS packages for File Transfer from one location to the other using FTP task.
●Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
●Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
●Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
●Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
●Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
●Involved in performing Audits and recovery operations of SSAS objects.
●Assess the risks and recommend/ install service packs or hot fixes when needed.
●Guardium Tool for Auditing and security Purpose across the servers in the inventory.
● Configured Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
●Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
●Configured Bi –directional transactional replication and have resolved many of the issues related to replication
●Created Numerous known error records to problem tickets
●Nimsoft tool used to alert as a ticket for all the parameters set to look after the MSSQL server in organized way
●Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.
●ITIL Tool HP Service Manager was used to create Incident, Service and Change-Requests for all the issues and they would be updated with the solutions respectively and resolved.
Environment: MS SQL Server 2005, 2008 R2, 2012,2014, 2016, Windows 2003 Server, Windows 2008/2008 R2, Windows 2012/2012R2 Server, Linux, Unix, Oracle, SQL Toad MS Visual Studio 2010, SSIS Packages, Excel, HTML, NetBackup tool, Guardium tool, Nimsoft Tool, HP Service Manager, Informix, IBM DB2.
Cambridge Associates LLC Jan 2016 – Sep 2016
Arlington, VA
Sr. MSSQL Server DBA/Developer
A stock market enterprise with various potential clients and various markets as well across world, share\stock data were residing in place to build Portfolios in business market and there were many applications that were in house to maintain this data and impart needable on application front end website for client users.
Responsibilities:
●Always-On, High availability environment with three clusters of two nodes, with two clustered nodes in one domain and rest in another domain.
●Design and implemented automated restore using SSIS in this environment.
●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
●Completely redesigned the SSIS package that will influence the capital’s market Database.
●Designed many queries and stored procedures, corrected to work according to desired objective.
● Used Red Gate for backups and maintenance jobs which includes updating statistics, database integrity checks
●Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
●Day-to-day activities were to serve requests from users and to work on the improvement tasks for SQL server to automate manual works that were in place.
●Replication is massive in this environment, as there are many servers that are connected with the databases that are linked by replication. As the data needs to be same across the testing servers and application.
●Various deployment methods were in place for application process. Tasks or assignments to automate were accounted using JIRA.
●Framed out working on automating the restore process for the databases that are involved in
Availability group and replication.
●Created SSIS packages for File Transfer from one location to the other using FTP task
●Service Now is the ITIL tool used to record the incidents, JIRA tool was used to maintain the internal work process.
●Worked on troubleshooting application related performance issues, like oscillating CPU, extensive memory usage.
●Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
●Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
●Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
●Involved in performing Audits and recovery operations of SSAS objects.
●SSRS
●Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.
●Learning and working knowledge on Amazon Web Services (AWS). As SQL Servers were being moved to cloud.
●Monitor network communication.
●Update systems as new version of OS and application software comes out
●Implement the policies for the use of the computer system and network
●Documentation in form of internal Knowledge Base
Environment: MSSQL Servers 2012, windows Server 2012/2012R2, Spotlight, SQL Data Compare, SQL Compare, Report Sync., PowerShell ISE, Microsoft Visual Studio, Amazon Web Services (knowledge)
PepsiCo Inc. [HCL America Inc.] Nov 2014 – Dec 2015
Plano, Texas
MS SQL DBA
Branded with thoughts to build entrepreneurs with the ideas within themselves a team of HCL came forward to support infrastructure of PepsiCo Inc. to support and HCL is one of the Top notch company in the field of IT infrastructure globally. This is inclusive of marketing sectors India, North America, Russia, Europe, and Middle-East Asian Countries.
Responsibilities:
●Our inventory is huge consisting of more than 3500 MS SQL servers globally
●Installed, managed and administrated the MS SQL Server 2014/12/08/05 Production and Non Production Servers
●The Customer Loyalty program is developed for Retail Industry. This system automates Customer enrollment, Partner Management, Customer transactions, their Points management, Shipping, Points Bonus and Campaign Management. This system involves an OLTP system and Data Warehouse system for Campaigns
●Worked with DTS packages to load the massaged data into Data warehousing system.
●The project involved Manufacturing and Logistics solutions with planning and scheduling for stuffing, destuffing, Billing, vendor-managed inventory and warehouse management
●Handled up to 2.5 TB size database in Active Passive clustered Environment.
● Used NetBackup Tool for backups and maintenance jobs which includes updating statistics, database integrity checks
●Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
●Created Logins for the users and manage their permissions.
●Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
●Used Bulk insert to load huge tables.
●Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
●Implemented partitioning on large table to get the performance.
●Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
●Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
●Performed Migrations for almost about 80 PEPSICO Inc. legacy database SQL Server migration from SQL 2000/2005 to SQL Server 2012/2014 databases, after running the server side trace to know about the depreciation factors and announcements
●Extracted data from various sources like SQL Server 2008/2012/2014, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
●Created SSIS packages for File Transfer from one location to the other using FTP task.
●Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
●Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
●Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
●Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
●Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
●Involved in performing Audits and recovery operations of SSAS objects.
●Assess the risks and recommend/ install service packs or hot fixes when needed.
●Guardium Tool for Auditing and security Purpose across the servers in the inventory.
● Configured Transactional Log Shipping between Primary and Secondary Servers depending on the business requirements.
●Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
●Configured Bi –directional transactional replication and have resolved many of the issues related to replication
●Created Numerous known error records to problem tickets
●Nimsoft tool used to alert as a ticket for all the parameters set to look after the MSSQL server in organized way
●Faster Delivery rate of the resolution and critical thinking was also as a part of Experience as part of the project.
●ITIL Tool HP Service Manager was used to create Incident, Service and Change-Requests for all the issues and they would be updated with the solutions respectively and resolved.
Environment: MS SQL Server 2005, 2008 R2, 2012,2014, Windows 2003 Server, Windows 2008/2008 R2, Windows 2012/2012R2 Server, Linux, Unix, Oracle, SQL Toad MS Visual Studio 2010, SSIS Packages, Excel, HTML, NetBackup tool, Guardium tool, Nimsoft Tool, HP Service Manager, Informix, IBM DB2.
Title Max Financials April 2014- Nov 2014
Atlanta, Georgia
MS SQL DBA
The TMX Finance family of companies is one of the largest and fastest growing consumer specialty finance companies in the United States. With brands that include: TitleMax, TitleBucks, InstaLoan, Equity Auto Loan, TMX Credit, and AutoCash, TMX Finance is comprised of a diversified product offering. TMX Finance has over 1,200 stores spanning 14 states and has aggressive growth plans to double in size in the next three years.
Responsibilities:
●Installed, managed and administrated the MS SQL Server 2012/08/05 Production and Non Production Servers.
●Setup development, testing and production environment with SQL Server 2012 and 2008 R2 Enterprise edition.
●Performed installation of SQL Enterprise 2005 64-bit version on Windows 2003, 2008 servers and VMware servers on Enterprise systems of Clustered and standalone servers in enterprise datacenters. Patch applications.
●Handled up to 1.8 TB size database in Active Passive clustered Environment.
●Involved Upgrade and Migration of SQL Server 2005/2008 in placed, side by side to MS SQL Server 2012.
●Worked in huge Replication Environment.
●Configured and worked on Database Mirrored Environments.
●Performed Failover drill tests to check the High Availability during disasters
●Worked on High Availability 2012 Solutions Always On
● Used Red Gate for backups and maintenance jobs which includes updating statistics, database integrity checks
●Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases.
●Created Logins for the users and manage their permissions.
●Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
●Used Bulk insert to load huge tables.
●Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to set-up ideal memory, min/max server options
●Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
●Modified Stored Procedures and complex T-SQL queries to improve query execution process
●Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans
●Configured DB mail by creating accounts and profiles.
●Monitored alerts using Fog Light and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
●Provided On Call Production support.
●Installation, administration and 24/7 production support for OLTP and Data warehousing databases on IBM DB2.
●Implementation of DB2 STMM in OLTP Environment which provides the ability to DB2 to tune most memory related parameters itself.
●Extensively used different Data movement utilities like IMPORT, EXPORT, and LOAD utilities to load data.
●Performed Reorgchk, Reorg, Run stats and rebind as and when necessary to eliminate the defragmentation
●Created SSIS packages for File Transfer from one location to the other using FTP task.
●Implemented partitioning on large table to get the performance.
●Tuned stored procedures by using execution plans.
●Continuous monitoring server health with Idera
●Worked extensively on third-party tools like Redgate for backup and restore.
●Used table hints in the queries to avoid locks in the server.
●Created missing indexes on the tables by running Database Engine Tuning Adviser.
●Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
●ITIL Tool HP Service Manager was used to create Incident, Service and Change-Requests for all the issues and they would be updated with the solutions respectively and resolved according to SME standards of maintaining the databases.
Environment: MS SQL Server 2005, 2008 R2, 2012, 2014, Windows 2003 Server, Windows 2008 R2 Server, Unix, LINUX, IBM DB2, ERWIN, MS Visual Studio 2010, SSIS Packages, Excel, HTML, Idera, RedGate.
TCF BANK Sep 2013- Mar 2014
Minneapolis, MN
SQL Server DBA/Developer
TCF Banks are affiliated with TCF Financial Corporation, a financial holding corporation based in Minnesota. TCF has 444 banking offices in Minnesota, Illinois, Michigan, Colorado, Wisconsin, Indiana, Arizona and South Dakota. TCF is now the 10th largest U.S. Visa® Classic debit card issuer ranked by sales volume.
Responsibilities:
●Worked on Client/Server tools like SQL Server Management studio (2005), SQL Server Enterprise Manager (2000) and Query Analyzer to Administer SQL Server
●Migrated SQL server 2000 databases into SQL server 2005 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation
●Setting up and Monitored transactional replication, Database mirroring on Production, QA and Development servers
●Migrated DTS packages into SSIS packages
●Handled up to 2 TB Size databases with clustered and stand-alone environment
●Configured Transactional replication on migrated server
●Wrote the packages using SSIS in SQL 2005
●Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s)
●Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
●Integrated SQL traces with Perfmon log to have better graphical analysis to find system bottlenecks
●Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users
●Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe)
●Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks
●Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery
●Used DTS packages to move logins and jobs from one server to another server
●Used log shipping for synchronization of database
●Good experience in data modeling and metadata services
●Monitoring SQL server performance using profiler to find performance and deadlocks
●Created Stored Procedures, Triggers, Views and Functions for the Application
●Extensive testing on the Performance of the Stored Procedures
●Creating roles and users in Informix using SQL, Migration of SQL to Informix.
Environment: TSQL, MS SQL SERVER 2000/2005/2008, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET, C#, WINDOWS SERVER 2008, IIS, SSAS
ICICI Bank, India Aug 2009 – July 2012
SQL Database Developer
MSSQL DBA/MSSQL Developer
ICICI bank is INDIA’s largest private sector bank by market capitalization and second largest overall in terms of assets. The bank is expanding in overseas markets and has the largest international balance sheet among Indian banks.
Responsibilities:
●Applied Normalization rules in designing the database.
●Created Entity relationship diagrams ER-Diagrams, function relationship diagram, Dataflow Diagrams and enforced all referential integrity constraints.
●Developed database objects like tables, views, stored procedures, indexes etc.
●Tuned SQL statements using views and stored procedures.
●Rebuilding the indexes at regular intervals better performance.
●Wrote various stored procedures for the purpose of application development.
●Design and implemented data access stored procedures and triggers for automating tasks.
●Extensively used joins and sub-queries to simplify complex queries involving multiple tables.
●Responsible for creating DTS packages and scheduling packages
●Managing of users including creation/alteration, grant of system/db roles and permissions on various database objects
●Created SSIS packages for File Transfer from one location to the other using FTP task.
●Extracted data from various sources like SQL Server 2008/2012, Oracle, .CSV, Excel and Text file from Client servers and through FTP.
●Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
●Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in database design process and data modeling process.
●Created Data-driven Packages in SSIS 2012 as part of the automating the process for the Referral Process.
●The packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion.
●Reviewed & Tested packages, fixing bugs (if any) using SQL 2005 Business Intelligence Development Studio.
●Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
●Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
●Involved in Staging Partitions and Usage Based Optimization (UBO) mechanisms for SSAS 2012 and 2008 OLAP databases.
●Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
●Involved in performing Audits and recovery operations of SSAS objects.
●Assess the risks and recommend/ install service packs or hot fixes when needed.
Environments: SQL SERVER 2000, DTS packages, Crystal Reports 6.0, Microsoft Visual Basic 6.0 and windows 2000/2003.
Contact this candidate