Sergey Kochengin

Senior Database Administrator

*** ***** **** **., **********, GA 30022 acx853@r.postjobfree.com 678-***-****

EXPERTISE SUMMARY

Strong experience of systems and database administration. Installation, configuration, performance tuning, patching, and maintaining high availability SQL servers’ farms. Maintaining development, staging and production environments. Backup and recovery, data deployment and database objects synchronization between environments.

Database schema design, development, and implementation. Integrating different data sources using linked servers, SSIS and ETL packages, PowerShell scripts. Developing, monitoring and maintain database and windows jobs.

Data analysis and presentation using SSRS (including data feed from Accounting, e.g. Billable Hours analysis, Timekeeper activity, etc. reports). Some data scientist background (TensorFlow, R, Python, and Hadoop).

Very strong Software Engineer / Developer background (.NET C#, Java). Developing Web, Windows, and Mobile applications.

Strong experience building publicly available data harvesting scripts.

M.S. in Mathematics and Computer Science, Microsoft Certified Business Intelligence Developer.

EXPERIENCE

Systems and Database Administrator, Software Engineer 2005 – Present

King & Spalding, LLP – Atlanta, GA

King & Spalding is an AmLaw100 law firm with more than 20 offices around the world, and over 2,000 lawyers and staff.

Manage Microsoft SQL server (2005, 2008R2, 2012, 2014) installation, configuration, administration (backups, mirroring, performance tuning and monitoring), in development, staging and production environment. Experience with SQL server clusters.

Maintain security and configure SQL servers’ audits.

Design and develop database schema for numerous web applications.

Database schema and query optimization, including intelligent de-normalization, views, triggers, indices, and stored procedures; monitoring and resolving table locking issues. SQL server profiling and monitoring using SQL server mail and extended events.

Design, plan and implement data collection into a data warehouse from multiple external sources

oImplement linked servers and database jobs, ETL packages for SSIS, PowerShell scripts, Windows jobs.

oIntegrate with Interaction CRM, LegalKey, Aderant, HR data feed (Executive Office, UltiPro), and Lexis Nexis Courtlink (ftp server).

oProcess data sources in both SQL and non-SQL formats (SharePoint lists, SharePoint collections, XML, Excel, proprietary formats on external ftp servers)

oIntegration with Access and Access Forms, and resolving special characters, collation issues, and dirty data processing.

Perform data analysis and presentation via complex Crystal, Excel and SSRS reports

oRecorded time summary, billable hours, weekly hours, pending time entries, salary model for Accounting.

oSSRS server administration, installation, configuration, backup, upgrade (from 2008R2 to 2012)

Designed and developed SQL based rules engine for automatic data processing of LKID data

Design, develop and maintain numerous ASP.NET web applications accessible via the firm intranet and mobile devices; These provide lawyers and staff with improved productivity and time-savings.

oPartner Voting Tool, Time Off Tracker, UPS Shipping, Conference Room Reservation, Billing Rates Query, Exception Manager, Client Matter Search, LegalKey Initiative (LKID) Database, Catering, TimeValueReport

oIntegrate web applications with Interaction CRM and iManage CMS using both APIs and backend databases.

Design, develop and code SharePoint 2010 and 2013 SharePoint web parts, including Control and Page templates

oAll Personnel Search, Client Matter Search, Practice Group Rosters, Lawyer Expertise, Interaction Activities, MyWeather, Learning Management System reports, Client Contacts, Group Announcements

oSearch features include advanced and phonetic search as well as facets for search refining

Perform SharePoint frontend development using InfoPath

Develop a variety of console applications including an internal objects export script for Oracle WebCenter Interaction (formerly BEA AquaLogic/Plumtree), enterprise security automation (synchronizing users, groups and permissions from database source to Active Directory and SharePoint), SharePoint collection export for mobile applications, and report emailing scripts

Designed, developed and implemented the King & Spalding mobile Firm Directory and mobile Partner Voting Tool on Android and BlackBerry

Created a comprehensive project plan for the King & Spalding reporting infrastructure upgrade

oImplemented upgrade and conversion of legacy Crystal 10 reports to work with the new financial system (Aderant Expert)

oWorked with Crystal Enterprise 10, Crystal Enterprise 2008, SQL 2008 R2, SSRS (SQL Server Reporting Services), very extensive SQL (stored procedures, views, triggers, cursors)

TFS server (source control) administration, and build and deployment automation

Developed components for www.kslaw.com upgrade. Oracle WebCenter Interaction (former BEA Aqualogic 6.0, former Plumtree 5.0 5.5), .NET 3.5 (C#), Plumtree idk 6.0, IIS 6.0, (MS SQL 2005,T-SQL, views, stored procedures, triggers)

Senior Software Engineer, Database Administrator, Programmer 1999 – 2005

Macquarium Intelligent Communications – Atlanta, GA

As database administrator analyzed clients requirements, designed database schema, performed installation, configuration and maintenance of Oracle, Sybase, Microsoft SQL server, Access, MySql, Postgre SQL.

Designed, developed and managed iCoke integration with ePrize, DNA mixer, and MultiCity using Java, Jsp, JavaBeans, Servlets, WebSphere 4 and 5, Oracle 8i, and integration with Coke UCD

Designed, developed and managed Sprint advertisements on www.yahoo.com and integration with www.sprint.com using PHP 4.03, MySql, XML, and Free BSD

As part of the Yahoo Portal Solutions team, designed and built the Sabre extranet and “MySabre”, a highly scalable, multilingual airline ticket ordering application used by travel agents worldwide

Created several brand building campaigns for Coca-Cola on howdoyouhangout.com using Java, Jsp, JavaBeans, Servlets, WebSphere 4 and 5, Oracle 8i, integration with Coke UCD, and data mining

Designed and developed UPS Press Room (web-based pressroom publishing wizard) using Vignette Content Management Server and Jsp

Developed content management and portal-based intranet for Delta using Documentum and Chiba integration, Java, Documentum APIs and workflows, and Tibco portal builder consulting

Architected, designed, developed and maintained Interwoven’s TeamSite based on a content management system for managing announcements, events, promotions, press releases, and product and home pages for Argentina, Australia, Brazil, France, New Zealand, United Kingdom, United States and Merial corporate web sites

Designed, built and maintained e-commerce website www.misterart.com (Coldfusion)

Managed four team members as part of day-to-day operations

EDUCATION

M.S. in Mathematics Emory University, 1997

M.S. in Mathematics and Computer Science Emory University, 1999

- GPA: 3.95

Microsoft Certified IT Professional (Certification ID: 7953153) December 2010

Contact this candidate