![]() Solid experience in UTIL based ticketing system.Experience of working in mixed environments with Oracle 10/11 g, Sybase, and MySQL.10 TB database administration and support experiences in a production environment.Design and implement DDL trigger based alert system for SQL Server and database level events.Design and implement logon trigger for auditing requirement.Experiences of working with DBA tools, including IDERA Suite, SQLLiteSpeed, Sitescope monitors.Experiences of working with databases for Sharepoint 2010, ERP, CRM, SiteScope 2010, Kronos, SCOM.Investigate and provide proof for virtualization of SQL server instances in VmWare.Complete analysis of database performance with execution plans, DMVFs, traces and perfmons.Design corporate level audit solution with SQL Server 2008 R2 Audit.Design, test and implement Resource Governor to control customer applications that dominate SQL Server resources, thus preventing run-away queries freezing up SQL Server.Help clients achieve huge disk space saving and better performance by designing and implementing database compression with optimal performance and balanced resource overhead.Provide customer high availability solutions by designing, building and supporting SQL Server 2012/2008R2/2008/2005/2000 multi-node multi-instance clusters.Proven customer-facing experiences and skills to keep clients satisfaction. Technical account manager providing primary DBA support for multiple clients.Evaluate SQL Server 2014 in test environment.In charge of schema releases for DEV/QA/PROD.Revamp RDL upload approach with rs utility.Automate new database creation with AlwaysOn Availability Group.Migrate SQL Server 2005/2008 databases to SQL Server 2012 with HADR.Design, implement and support SQL Server 2012 AlwaysOn Availability Groups for call center applications.Principal Database Administrator telecommute.Red-Gate SQL/Data Compare, Idera, HP SiteScope, NetIQ, Advantage, Quest Spotlight, Lumigent Log Explorer, Toad, Navicat, undocumented DBCC/xp/stored procedure/functions. SQL Server 2014/2012/2008R2/2008/2005/2000 administration, multi-node multi-instance clustering, HADR AlwaysOn, SSRS, SSIS, SSAS, DTS, installation and patching, transactional replication, database mirroring, log shipping, backup and restore with MS SQL native/SQL LiteSpeed/Idera SQLSafe compression, resource governor, IFI, performance tuning, DMVF, database monitoring and alerting, Database Engine Tuning Advisor, security best practice, audit, T-SQL querying, stored procedure, function, trigger, view, CTE, UNPIVOT, TDE, XML, data modeling, physical design, online index rebuild, DDL trigger, WMI events alert, MS Fulltext/Alta Vista/Lucene text search, DBCC, ODBC, database mail, disk space tracking and trend analysis, PAGE/ROW compression, data mart sliding window partitioning, partial filegroup backup and restore, VLDB, CDC, CT, PBM, ADSI Active Directory querying, linked server for SQL OLE DB, Oracle, Sybase, MS Access Jet driver. A team player preferring to work independently Customer focused with well-rounded personality.Publication grade writing skills and an advocate of documenting, communicating and knowledge sharing.Proficient in analysis, trouble shooting and project design methods Professional Mission-driven working attitude with persistence and patience.Non-stop technology absorber without feeling boredom Detail-oriented self-starter and quick learner.Good exposure to MS BI with an interest of becoming a DWA.16 years of hands-on production database administration and development experiences in consulting, academic, financial, environmental, government, software, medical, pharmaceutical and SAAS areas.Also a certified MCDBA, MCSE, MCP, MCP I, A Microsoft certified MCTS and MCITP in SQL Server 2008 DBA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |