хм, в сами запросы я ничего не добавлял, а только создал благоприятные условия для их работы (индексы) - чтобы любая проводка не вызывала тестирование дисковой подсистемы (table scan), чтобы стала возможна многопользовательская работа с базой

да я и не парюсь особо
но если небольшая подготовка увеличит шансы на успех, то я её безусловно проведу - семь раз отмерь, как говорится

Эккаунт в LinkedIn есть, и резюме там тоже есть :)

Касательно "разброса описаний и структуры" - недавно на глаза попалось резюме какого-то англичанина индусского происхождения. Оно своим видом вызвало ассоциации с некрологом - всё черное, много жирного шрифта. ;)

да, это классика - устранение одних узких мест порождают другие узкие места

Товарищи, кто в теме, покритикуйте, пожалуйста, english grammar & spelling :

FirstName LastName
Phone: +7(916)xxxxxxx
Email: xxxxxxxx
Skype: xxxxxxx

Company 4
Top 10 Russian Investment Bank (www.company4.com)
April 2009 – Present time
Senior DBA
Duties:
• Installation, patching and administration of MS SQL2005/2008/2012, queries and stored procedures optimization, performance issues management and solving, health monitoring (Quest Foglight/Spotlight, Performance Dashboard, SCOM, etc);
• Installation and administration of MS Cluster Server, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MSMQ;
• Oracle 10&11 ad-hoc administration (Linux, Windows);
• Administrative scripts (cmd, vbs, powershell) & automation;
• Audit, consolidation and support of geographically spread SQL environment;
• HA & DR solutions planning, rollout, automation of DR tests (replication, mirroring, clusters);
• Backup/restore policies (RTO&RPO planning, verification);
• Optimization and reorganization of existing DBMS solutions, migrations, security assessment;
• Capacity assessment and planning;
• Development of Internal IT resources (Oracle APEX, MS SQL, ADAM);
• Internal infrastructure projects management (planning, technical review, execution state, rollout and support).
• Internal DBA's documentation, standards & best practices (development, technical review, keeping up-to-date);
• Playing role of SQL technology & solutions expert;
• Managing international DBA team as deputy of DBA head.
Key accomplishments:
o Designed and implemented SQL Central Management Server with flexible search functionality & integration with SCOM (CMS, SSRS, stored procedures). This allowed to simplify management of more than 150 SQL servers by geographically spread DBA team;
o Created and maintained DBA distributed repository with custom diagnostic & service scripts. This allowed to minimize time of troubleshooting and helped junior DBAs to provide higher level of service;
o Designed and created alerting system which tracks all critical alerts and events (MS SQL) helping DBA team react proactively;
o Built highly secured HR SQL instance with restricted access only for HR staff (bonuses and compensations application);
o Created and maintained internal standards & technical instructions for DBA team which helped to unify new installations and keep legacy servers equally configured and monitored;
o Did reverse engineering and helped to rollout patch for Financial Regulator’s reporting software in time for AppSupport team which helped our company to avoid penalties;
o Implemented centralized storing solution for all DBAs service accounts (PasswordSafe) which allowed to avoid password loss and helped to ease system management and comply with audit demands;
o Has initiated, driven and implemented disk space saving initiative worth more 50000$ for business units (Redgate products).

Company3
Top 10 Russian Investment Bank (www.company3.com)
January 2006 – April 2009
Senior DB Administrator (Sybase/MSSQL)
Duties:
• Installation and administration of MS SQL 2000-2005 (~50 servers), queries and stored procedures optimization, performance issues troubleshooting;
• Installation, tuning and administration of Sybase ASE 12.5.х (Windows&Solaris; 20 servers);
• Backup/restore policies;
• Administrative & maintenance scripts (Windows, Solaris);
• Informix Dynamic Server administration (Solaris);
• Installation, tuning and administration of Windows servers (Windows 2000-2003);
• Installation and administration of Microsoft Cluster Server (10 in Prod);
• Tuning and administration of VERITAS Cluster Server (Solaris);
• Networked storage array administration and monitoring (EMC Clariion CX3-80);
• Installation and administration of business applications (Business Objects, Odyssey, Murex);
• Consultancy for in-house SQL developers.
Key accomplishments:
o Has built custom code page for production Informix server, which helped to implement new business functionality;
o Designed & implemented environment cloning solution for financial front-office application - several UAT&DEV envs (Solaris, Sybase, Odyssey TripleA) 20000$ worth each.

Company2
Financial software solutions (www.company2.ru)
August 2004 – January 2006
Senior DB Administrator (Sybase/MSSQL)
Duties:
• Sybase ASE 12.X installation, tuning and administration (Windows 2000, Solaris, HP-UX); routine automation scripts (W2k);
• Sybase Replication Server installation, patching, tuning and troubleshooting (Windows 2000, Solaris);
* MS SQL2000 server installation, patching and administration;
• Installation, tuning and administration of Windows 2000 servers;
• Remote and on-site client technical support (performance issues with Sybase ASEs, MS SQL servers, Sybase Replication Servers and Company2 software);
• Replication scripting and maintenance (Sybase ASE, MSSQL);
• VBA-based scripts for Sybase performance analysis (development and support);
• 3rd line client support and crisis/emergency server administration.
Key accomplishments:
o Has developed Sybase ASE performance analysis tool (VBA, sysmon) which saved time for analysis by 70%;
o Has developed replication generator, which dynamically builds replication based on custom credentials and existing application modules (MS SQL, cmd). This saved time (~3 hrs) per each visit to a client.

Company 1
Hardware and software solutions (www.company1.ru)
September 2000 – August 2004
Database developer (Sybase/MSSQL)
Duties:
• Databases development (architecture, T-SQL development).
• Installation and administration of Windows (NT, 2000);
• Installation and administration Sybase ASE, MS SQL 2000.
Key accomplishments:
• Has designed and developed database for local ISP (dial-up & traffic aggregation and calculations, billing) using Sybase ASE 11.9 and T-SQL;
• Has designed and developed database for mobile payments processing which supported three main national GSM providers (MS SQL 2000, T-SQL).

Education
"MATI" – Russian State Technological University
M.Sc. degree, Aviation and Rocket technology
1995 – 1999

Courses
• O10gDBAI: “Oracle Database 10g: DBA I”, RDTEX (Moscow), 2010.
• O10gDBAII: “Oracle Database 10g: DBA II”, RDTEX (Moscow), 2010.
• O10gBAR: “Oracle Database 10g: Backup and recovery” RDTEX (Moscow), 2010.
• “EMC Clariion tuning and administration”, Microinform (Moscow), 2006.
• M2733:“Update of administration skills for MS SQL 2005”, Specialist center (Moscow), 2006;
• M2784: “Query tuning and optimization in MS SQL 2005”, Specialist center (Moscow), 2006;
• “Veritas cluster for Unix”, Symantec (England), 2006;
• “Server data structures, optimizer, query optimization methods Sybase 12.5.x”, Sybase CIS (Moscow), 2005.

Software
Databases: MS SQL (2000-2008R2), Sybase ASE (11.9-12.5), Sybase Replication Server (12-12.5), Oracle (10-11), Informix, Mysql.
Performance&Troubleshooting: MS Profiler, Quest FogLight&Spotlight, MS SCOM, DBArtizan, Bradmark Surveillance, sysmon.
Data modeling: PowerDesigner, Erwin
Backup software: Simpana CommVault
Service Desk: HP Service Desk
Issue tracking: JIRA