jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary certified sql server database administrator 6 years experience designing coding testing supporting nextgeneration database solutions sql server environment experienced creating ssis packages integrating data using ole db connection heterogeneous sources excel csv oracle flat file text format data using multiple transformations provided ssis data conversion conditional split bulk proficient designing creating database objects ms sql mysql environments created stored procedures triggers views finetuned slow queries proficient database performance tuning experience implementing windows clusters across multiple availability zones implemented sql server always availability group aws experience installing configuring administration maintenance mission critical client databases sql server 2008r2 2012 2014 2016 2017 versions extensive experience upgrading sql server place upgrade side side upgrade based application compatibility fixing orphan users experience implementing sql server security object permissions like creation users granting permissions assigning roles users auditing sql logins applying encryption deployment administration operational support production development test environments utilizing proper change management itil best practices using ticketing tools expert implementing troubleshooting high availability database servers using replication log shipping database mirroring failover clustering always ag strong experience understanding creating server level database level roles per business requirement experience configuring scheduling sql server agent jobs alerts operators maintenance plans database mail configuration facets transparent data encryption extensive experience monitoring performance tuning analyzing db performance issues skilled senior database administrator bringing 6 years experience design administration databases well key skills modeling warehousing data development enterprise architectures strategic collection use business intelligence proficient technical software languages tools learns new strategies quickly collaborative teamoriented firstrate oral written communication complex problemsolving decisionmaking abilities proactive database administrator 6 years experience database development production environments proven skills security management database maintenance establishing backup recovery processes safeguard data wellversed various programming languages including sql tsql technical skills information systems management document management root cause analysis database administration safety protocol skills organizational skills team building friendly positive attitude windows sql server tsql dell spotlight scom redgate sqlcompare data compare redgate sql toolbelt dataedo erwin ssdt azure ssis ssrs ssms dta jira raid mysql servicenow octopus deploy tfs mdw citrix idera diagnostic manager outlook skype business mfa san office 365 planner ag hadrdb hardening monitoring health check data exportdump importloadssis ssrs documentation analysis disaster recovery planning stored procedures windows server etl writing queries microsoft sql experience sql database administrator 022021 current chicago public schools chicago il installing configuring administering securing production nonproduction servers clustered nonclustered upgrading sql server 2012 sql server 2016 2017 experience implementing windows cluster across multiple availability zones implemented sql server 2016 always availability group aws experience setting database transactional replication reporting servers using backup restore methods experts database refresh prod lower environment per business requirements automated quarterlymonthly database refresh managed involved sql performance tuning identifying locking blocking issues using native thirdparty tools enhance boost performance sql dbs managed implemented ola hallengrens industries best sql server maintenance plan created schedules environments managed sql server logins database users roles involved daily user maintenance created database maintenance jobs perform full transaction log backups scheduled sql server agent job scheduler monitor database growth activities troubleshoot transaction log issue created configured mirroring disaster recovery providing weekly status information projects project manager wrote debugged stored procedures ddldml triggers functions per client requirements logical physical design database projects basis user requirements using erwin reporting weekly basis project manager extensively worked troubleshooting finetuning databases optimal performance worked performance tuningquery tuning execution plans trace flags sql profiler installation service packs environments used log shipping synchronization databases designed developed etl process using ssis load data various sources like ms access sql server 2014 oracle database expert data extraction transformation loading etl using sql server integration services ssis experience migrating sql server 2012 2014 sql server 2016 alwayson availability good understanding database data warehousing concepts oltp olap used ssis create etl packages validate extract transform load data data warehouse databases worked bcp data uploading module created ssis packages data transfer transform across locations multiple data sources per requirement created new tables stored procedures triggers using tsql refactored finetuned queries stored procedures tsql performing db backups db refresh db restores cleanup statistics update installed configured ms sql servers virtual environments using vmware analyze execution plans recommendimplement better execution plan experience monitoring tuning system resources associated database performance hit ratios io lock latch contention experience supporting aws db production development environment sql dba 042019 012021 apex systems athens ga created updated databases tables stored procedures triggers functions views configured administered troubleshoot multiple databases production staging environments clustered standalone environments prepared documentation disaster recovery plan involved installing failover clustering multiple nodes implemented database mirroring log shipping planned backup strategies scheduled backups performed restore operations managed security sql server databases creating logins creating database users creating roles assigning proper permissions creating server database audits worked creating reorganizing rebuilding indexes worked database space management performance monitoring alert management planned location files increased size number files performed tasks query optimization troubleshooting clientserver connectivity issues performance tuning monitored troubleshoot database server performance systemwide scale effectively identify network databases memory cpu disk space io related bottlenecks transferred data several servers using bcp dts generated reports extensively using ssrs providing resolution assigned tickets jira team track service desk per severity meet deadline sla due sql dba 062016 032019 apex systems bedminster nj installing configuring sql server configuring sql server reportinganalysis integration services consulting departments customers project status proposals working customers departments technical issues including software system design maintenance analyzing information recommend plan installation new systems modifications existing system consulting engineering staff evaluate softwarehardware interfaces develop specifications performance requirements designing developing software systems using scientific analysis mathematical models predict measure outcomes design consequences preparing reports programming project specifications activities status conferring project managers obtain information limitations capabilities analyze existing scripts tweak scripts address performance issues developing sql scripts implementing developing advanced sql queries using sql server outlining designing logical interrelation sets data able make scientific analysis making predictive analysis basis data interpretations using statistical softwares ssps sas creating analysis reports organization level team members external client presenting data analytics using set graphic tools graphs tabular visualization tools bachelor science information technology education training southern new hampshire university manchester nh additional information strong experience designing implementing backup disaster recovery strategies per rpo rto values created jobs alerts run ssis ssrs packages periodically created automated processes activities database backup processes ssis ssrs packages run sequentially using sql server agent job experience configuring maintaining full backup transactional log backup differential backup creating maintenance plans index rebuild index reorganize based fragmentation worked bcp data uploading module created ssis packages data transfer transform across locations multiple data sources per requirement expert data extraction transformation loading etl using sql server integration services ssis experience microsoft reporting service ssrs report authoring report management report delivery report security created reports sub reports charts tablix matrix hyperlink reports using ssrs excellent knowledge performance tuning stored procedures queries using tools like sql profiler database tuning advisor execution plans dmvs efficient coding standards