Candidate Information Name Available: Register for Free Title Sql Dba Mechanical Engineering Target Location US-GA-Cumming Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes

Candidate's Name
e-mail:EMAIL AVAILABLETel:PHONE NUMBER AVAILABLESUMMARY:Boris is a SQL DBA with over 15 years of experience.Boris is Snowflake, Azure Managed SQL, MySQL, SQL DBA in last 2 years.EDUCATIONMasters Degree, Electro-Mechanical Engineering (Kiev Polytechnic Institute, c.Kiev, Ukraine, 1988).Bachelor Degree, Electro-Mechanical Engineering (Kiev Polytechnic Institute, c.Kiev, Ukraine, 1986).TECHNICAL SKILLSSOFTWARE:SQL SERVER 7.0- 2019, Snowflake, MySQL8, Postgres SQL11, Foglight, SentryOne, Tivoli, LightSpeed, VISUAL BASIC 5/ 6/.Net (ADO, COM/DCOM), CRYSTAL7/8/9, CRM, PERL, ORACLE 8.0, POWERBUILDER 6.0, ASP, HTML, Java Script, XML, PL/SQL, DEVELOPER/2000, MS-OFFICE 2000/2007,,PERL, ADOBE PHOTOSHOP 4.0, Unix Shell Script, VSS.OPERATING SYSTEM:WINDOWS /2000/XP/2003/2008/2012/2016,WINDOWS NT 4.0, Unix Shell ScriptsAPPLICATIONS:Medical Insurance, Financial, Data Warehouse, CRM, EPR.PROFESSIONAL EXPERIENCECity of Portland,Oregon November 2021 - PresentSr. SQL DBASupport Cluster(AG) PROD\UAT\DEV environments SQL 2014\2016\2019.Writing\configuring\optimizing Complex TSQL\SP as per client's requests.Monitor PROD\UAT\DEV environments through RedGate, Rubrik Monitoring software.Modified\Deployed SSIS\SSRS based on Clients requirements.Environment: MSSQL2014\2016\2019, AG, SSIS, SSRS, RedGateInspire Brands, Inc (BWW, Sonic, JJ, Arbys, Baskin Robins) May 2020-November 2021Sr. SQL/Snowflake/MySQL/Azure SQL DBA(Data Engineer)Build, Audited, configured, patched, tested, monitored, and supported MS SQLCollectors (SQL2008/2012/2014/2016/2019, High Availability groups, cluster, TSM).Support, administer Clients databases on Azure: CosmosDB, Snowflake, Postgres, MySQL.Creating, administrating Warehouse notebooks, roles, credits on Azure CosmosDB, Snowflake.Designing and optimizing SQL Database modelling (normalization, relation, relativity).Troubleshooting PROD performance, tuning\analysing Application scripts (SSIS\SSAS).Installing\configuring 10+ SQL 2016 AWS/Azure servers.Support Azure SQL 2019 Exadata (BigData, DataLake Analytics).Established HA group (SQL2014\2016) for synchronization of data.Environment: MSSQL2014\2016\2019,Snowflake, Azure, AWS, SentryOne, CosmosDB, TSM, PowerShell.Liveperson, Inc September 2017  May 2020Sr. SQL DBAMigrated 100+ SQL servers from 2008 to 2016/2019(Standalone\Cluster) to AWS, Azure.Installed configured 100+ instances of SQL on AWS through snapshots or build ins.Installed and Configured 10+ SQL 2019 servers on AWS. Established Read-Scale AG (2016\2019) on AWS.Migrated several Oracle projects from ASM to AWS using AWS Data Migration Tool.Created, modified autosys backup jobs with Powershell, Unix Shell Script.Migrated Postgres SQL 11.2 to AWS with using DMS tool.Configured and supported SQL 2016 Cluster environment on AWSTroubleshooting PROD performance, tuning\analyzing Application scripts (SSIS\SSAS).Installing\Configuring Recovery Backup Strategy Software and Backup Models  Quest.Designed, developed, implemented Complex Data Warehouse Report System (Oracle Developer, ETL, SSIS, SSRS).Installing\Configuring 3rd party Monitoring Software on SQL boxes(NetBackUp, Entegra, Tivoli)Automating SQL code promotion pipelines through Datical, TFC and Jenkins tools.Audited, configured, patched, tested, monitored, and supported MS SQL Collectors (SQL2000/2005/2008, BMC, Log shipping, Tivoli, Integra, SSIS, SSRS).Installing\configuring Always On SQL 2016\2017 servers on AWSSupporting Cluster PROD environment SQL2005\2008\2012\2016 on AWS, Azure.Environment: MS SQL 2014\2016\2017, AWS, Azure, Snowflake, Postgres11, MySQL 8CitiBank, Inc. June 2007  September 2017SQL DBABuild, Audited, configured, patched, tested, monitored, and supported MS SQL Collectors (SQL 2005/2008/2012/2014,High Availability groups,cluster, TSM).Created Ad-Hoc modules (Ledger, Accounting, Time Entry etc..) using Oracle JDEdwards.Developed, implemented, supported Back-end developments for various Web- based, Client-Server Financial (Credit Card) applications.Net (ADO, COM/ DCOM), SQL2008\SQL2012(T-SQL),SQL 2008\SQL2012 (SSRS).Troubleshooting PROD performance, tunning\analyzing Application scripts(SSIS\SSAS).Designing\configuring Data Mart Warehouse(ETL), SQL2012(ETL,SSIS)Designed, developed, implemented Complex Data Warehouse Report System (Oracle Developer, ETL,SSIS,SSRS).Install\Configuring Recovery Backup Strategy Software and Backup Models  LiteSpeed(Quest).Creating\Modifying\Supporting Autosys jobs(Unix,IBM DB2,Perl Scripts).Installing\Configuring 3 rd party Monitoring Software on SQL boxes(NetBackUp, LiteSpeed, Entegra, Tivoli)Analyzing historical data using SQL Server Analysis Services [SSAS].Analyzing historical Data warehouse data using ETL functons.Support Cluster PROD environment SQL 2008\2012Audited, configured, patched, tested, monitored, and supported MS SQL Collectors (SQL2000/2005/2008, BMC, Log shipping, Tivoli, Integra, SSIS, SSRS).Installing\configuring SQL\SSRS\SSIS\SSAS on SQL 2005\2008\2012 boxesInstalling\configuring Always On SQL 2012 boxesSupporting Cluster PROD environment SQL2005\2008\2012Writing complex reports using SQL Server Reporting Services [SSRS].Supporting PROD environment SQL2000\2005\2008\2012 and Oracle 10g.Validating VMware host requirements for SQL server install\configurationsPerforming tuning,\analyzing on complex T-SQL using SSAS.Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients using all components of SQL 2005 Management StudioTuned complex T-SQL, troubleshoot database performance problems, supported new and existing application development, worked closely with development groups on logical database design to support new and existing applications (SQL 2000/2005/2008).Evaluated the benefits of available system upgrades and enhancements (SQL 2000/2005/2008/2012).Monitored and fine tuned of the system for optimal performance, taking responsibility for production patching, maintenance and support activity (SQL 2000/2005/2008/2012).Environment: MS SQL 2008/2012/2014,VMWare, Oracle JD Edwards,Net-Back Up, TIVOLI, LiteSpeedCosta Cruise Lines, Inc. (Hollywood, FL) November 2004  June 2007SQL DBA/DeveloperDeveloped, implemented, supported Back-end developments for various Web- based, Client-Server Financial (Credit Card) applications.Net (ADO, COM/ DCOM), SQL2000, Crystal 9 and Oracle10.Configured, patched, tested, monitored, and supported MS SQL instances (SQL2000).Designed, developed and implemented several ad-hoc applicationsVB.Net (ADO), SQL2000.Designed, developed, implemented Complex Data Warehouse Report System (Oracle Developer).Database SQL 2000- Maintenance, Back Up, Recovery, Tasks Automation (DTS, T-SQL, RDBMS, User Roles and Access).Environment: SQL 2000, VB6, .Net (ADO, COM/DCOM), Oracle 10g, Crystal 9, VSS 6.0.Emplifi, Inc. (Pittsburgh, PA) June 1999  November 2004Programmer/AnalystTeam member in Warehouse project for Arrow Industrial used Visual Basic 6.0, SQL 7.0Developed, implemented, tested Web Pages for Intellitrans, LLC (JScript, ASP, XML).Designed, developed and implemented Medical Software  LightYear- .Net (ADO, COM/DCOM),Designed, developed, implemented Back End Database: SQL 2000(tables, SP, views, DTS, security etc..)Database SQL 2000- Maintenance, Back Up, Recovery, Tasks Automation (DTS, T-SQL, RDBMS, User Roles and Access).Created Relational Database for NCAD (back end) using Oracle8.Developed NCAD application (front end) using Visual Basic 6.0, Oracle 8.Environment: VB 6.0(ADO, COM/DCOM), Crystal Reports 7/8, Access, Excel, Oracle8, ASP, XML, HTML, JAVA Script, VB Script, SQL Server 6.5/ 7/ 2000, VSS.