![Permanentaddress : D/O Sharanappa Alure
# 9-4-259, Ve e rabhadreshwar Nilaya, Sai colony.
Land mark : Backside of Nandi Pe trol Pump,
Bidar - Karnataka,Pincode- 585401.
Declaration
I here by declare that the information furnished above is true to the best of my
knowledge.
Date:
Place:
[NIVEDITA.ALURE]](https://image.slidesharecdn.com/210ba85c-f5b1-4b0a-b7f9-a0b9a729b900-160302043719/85/NiveditaResumeDBA-5-320.jpg)
More Related Content
What's hot (20)
Viewers also liked (15)
Similar to NiveditaResumeDBA (20)
NiveditaResumeDBA
- 1. NIVEDITA ALURE E-mail : niveditaA111@gmail.com Phone : +91 741 149 4037 Career Objective To secure a challenging position as a SQL DBA in an established organization and utilize my technical skills and IT knowledge for managing organization projects. Profile Summery ? Having 1.6 year of experience in SQL Server (2005/2008/2008R2) Database Administration/ MSBI(Developer) on production support at Sun plus Software Technologies pvt ltd. Technical Summery ? Experience onInstalling,configuring,managing,monitoringandtroubleshootingSQLServer ? Planning, Implementing all types of Backup (Full, Differential, Transactional) and Restore Operations ? Providingday-to-daySupportandMaintenance of SQLServerdatabases ? Moving Data and databases from one instance to another by using Backup & Recovery, Export& Import,andAttach & Detach ? Space management including File groups, Managing Transaction Log files and Cleanup operations ? InstallingandconfiguringSQLServerandchangingConfigurationsettingsasperthe request ? PlanningandImplementingSecuritybestpracticesforSQLServer ? Settingupsecuritypolicesandcratingappropriate logins,rolesandapplicationroles ? Administrating high availability solutions like Log shipping, Database Mirroring, Clustering and Replication ? workingina teamenvironment ? Expertise in writing T-SQL (DDL, DML) queries, stored procedures, database triggers and exception handlers ? Expertise in Normalization and De-Normalization techniques ? Performance tuning of stored procedures and slowly running queries ? Experience in providing logging, error handling by using event handler and custom logging for SSIS Packages. ? Experience in performance tuning in SSIS packages by using row transformations, block and unblock Transformations
- 2. ? Experience in scheduling and monitoring ETL processes using DTS Exec utilities and batch files. ? Extensively used control & data flow transformations like OLEDB command, execute SQL task, sequence generator, derived column, conditional split, lookup and script component task etc., ? Expert in generating drill down reports, parameterized reports, linked reports, sub reports, filters, charts using SQL Server Reporting Services, MS Excel. ? Experienced in creating Ad-hoc reports, data driven subscription reports by using Report Builder ? Experienced in using global variables, expressions and functions for the reports. ? Experience in performance tuning, query optimization, client/server connectivity, running database consistency checks using DBCC Utilities SQL Server Profiler, Index Tuning Wizard, Database Engine Tuning Advisor (DTA) ? Created and managed users, roles and assigning necessary permissions. ? Expertise in implementing different types of Replication models such as Snapshot, Merge and Transactional ? Proficient with database backup and recovery procedures, and log shipping. ? Workedwith ETL andReports. ? Strongexperiencewith SQLServer2008,2008R2,2012 SSIS, SSRS ? Good knowledgeon T-SQLand Query Optimization. ? Good knowledgeon T-SQL and CTE and Store procedures ? Good experience andunderstandingof database design,relational integrity ? Experience increating Jobs,SQLMail Agent,and ScheduledSSIS Packages. ? Experience in providingLogging,Errorhandling byusingEvent Handlersin SSISPackages. ? Stronganalytical,problemtroubleshooting/solvingskills. ? Experience increatingthe reportsasperclient¡¯srequirementinthe form Table,Matrix and Charts. ? Experience increatingadhocreportsbasedon client¡¯srequirement. ? Educational Qualification Qualification Institute/ University Aggregate% Year of passing BE (Telecommunication) REC , Bhalki 60.15 2013 DIPLOMA(E&CE) Government Polytechnic College ,Bidar 68.18 2009 SSLC M.D.R school, Basava kalyan 73.47 2005 Technical Skill
- 3. Programming Languages C,C++ Databases SQL Server, MySQL Technologies MSBI(SSIS,SSRS,SSAS) OS Windows XP, Windows 7 Project Handled Project 1: MERITQ (Online feedbackapplicationbasedon the clientrequirement). Role: SQL DBA/ MSBI Developer Environment:ASP .NET , C#, ADO.NET, SQL Server 2008, MSBI,VS-2010 and SQLDBA Clients:VTU,SJCE Mysore,BMS Bangalore. Description : ? The systemis mainly designedforCollegesandaimedto provide goodQuality Education for the students. ? Feedbackcan be givenfrom anywhere throughout the world by connectingto the particular college website. ? Best Faculty, StaffReport, Department Summery Report,etc¡ ? Even Feedbackcan give through mobile. Project 2: Ziraffe (It is a complete ERP Solutionfor CBSC and International School) Role: SQL DBA/ MSBI Developer Environment:ASP .NE , C#, ADO.NET, SQL Server 2008, MSBI,VS-2010 and SQLDBA Clients: BIS (Bapuji International School) Bagalkot. Description : ? The systemis mainly designedforCBSC and International School. ? Complete ERP Solution. ? Modulesare Examination,Fees,Attendance,Inventory,etc¡ Responsibilities: ? Verifyingall instancesare upandRunning ? Rebuildingthe indexesatregularintervalsforbetterperformance ? Schedulingdailymaintenance tasksusingjobsandmaintenance plan ? Managing LoginsandPermissionsanddatabase levelpermissions ? IdentifyingandresolvingBlockingandDeadlockissuesbyusingActivityMonitor ? TroubleshootingTempDBandLogfile FULL issues ? UsedSQL Profilerfortroubleshooting,tuningof SQLServerperformance relatedtoIndexes, Statisticsandusingmetrics ? SchedulingjobsinSQLServerandconfiguringEmailsonsuccess/failure ? MonitoringLog shippingandtroubleshootingerrors
- 4. ? ResolvingMirroringsynchissuesUnsent/UndeceivedlogsthroughMirrorMonitor Environment: windowsServers2008/R2, MS SQL Server2008 R2/2012 ? Created monthly P&L Report for Attendance and each Formative and term exam according to grade and section levels of hierarchy groupings & drill downs. ? Configured the SQL Server reporting server for report publishing and created server roles for various users depending on their accessibility to various reports. ? Developed SSIS packages for importing data from Oracle system into SQL Server data warehouse. ? Scheduled jobs from SQL Server agent which run the developed SSIS packages on daily basis for data importing into SQL Server data warehouse and also set up the job notifications from Database Mail with detailed error logs. ? Created log tables for the data importing process execution results in SQL Server ? Used various script task, look up transformations, control flow tasks like FTP, bulk insert task, transfer job task, File System Task, Execute Process Task etc and different data flow tasks using T- SQL and Visual Basic (VB) scripts. ? Query tuning by removing unnecessary cursor and complicated joins. ? Configured the SQL Server Database mail for sending notification & alert emails to various operators ? Involved in administration of SQL server reporting services (SSRS) ? Configured Database mail, created operators, jobs and alerts for SQL Server Database. Environment: windowsServers2008/R2, MS SQL Server2008 R2/2012 Personal Skills:- ? Innovative and enthusiastic. ? Willingness to learn, industrious. ? Good communication and inter personal skills. ? Quick to absorb and retain new information and procedures. Personal Details: Father¡¯sName : SharanappaAlure Date of Birth : 21st November1990 Gender : Female Marital Status : Single LanguagesKnown : English,Hindi,KannadaandMarathi Hobbies : Solvingpuzzles,Browsing
- 5. Permanentaddress : D/O Sharanappa Alure # 9-4-259, Ve e rabhadreshwar Nilaya, Sai colony. Land mark : Backside of Nandi Pe trol Pump, Bidar - Karnataka,Pincode- 585401. Declaration I here by declare that the information furnished above is true to the best of my knowledge. Date: Place: [NIVEDITA.ALURE]