jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom summary six years professional experience database administration database design development support ms sql servers 2012 2014 2016 2017 2019 production qa development environments handson experience microsoft sql server database installation configuration administration maintenance performance tuning sql server 2012 2014 2016 2017 2019 handson experience implementing sql server high availability tools like log shipping clustering ms sql server performance tuning query optimization clientserver connectivity data transformation services running database consistency checks using dbcc expertise implementing different types high availability disaster recovery mechanism like replication models log shipping database mirroring clustering experience implementing sql server security object permission like maintaining creation logins users configuring permissions database authentication modes assigning roles users worked sql server 2016 migration sql server 20142012 worked creating packages jobs sending alerts using sql mail db mail experienced data movement excel access flat file oracle ms sql server using bcp ssis dts utility created linked servers sql server 2012 2014 also created dts package data transfer two environments experienced configuring reporting services developing publishing reports using microsoft power bi ssrs experienced replicating data using transactional replication merge snapshot expertness trouble shooting database issues like space issues deadlocks performance blocking hands experience migrating scripts production environment extensive experience creating modifying stored procedures triggers views cursors functions meet business requirements handson experience sql server tde encryption decryption experienced allocating system storage planning future storage requirements database system hands experience ssis package development deployment scheduling experienced preparing deploying transactsql tsql powershell scripts handson experience created azure sql database azure synapse azure develops performed monitoring restoring azure sql database performed migration microsoft sql server azure sql database extensive knowledge relational database management systems industry standards agile best practices excellent analytical interpersonal communications skills fast learner hardworking good team player worked 247 production database oncall support multitalented database administrator 6 years expertise designing testing coding database solutions various environments motivated selfstarter consistently meets deadlines succeeds highpressure environments skills technical skills rdbms ms sql servers 2012 2014201620172019 front end ms visual basic developer 2000 development environment sql business intelligence development studio sql server management studio enterprise manager query analyzer exportimport dts ssis reporting tools crystal reports 90 ssrs designer power bi performance tool database engine tuning advisor profiler performance monitor spotlight red gate server operating systems 20122014201620172019 configuration tools sql server surface area configuration reporting services configuration sql server configuration manager microsoft database upgrade advisor packages microsoft office lotus notes ms visio 2003 ms project hardware sun ibm as400 hp compaq dell cisco routers tools spss opnet erstudio veritas net certification microsoft azure fundamentals writing queries microsoft sql data testing experience sql database administrator 062021 current computer aid springfield il microsoft powershell database analysis continuous process improvement information systems management data conversion migration root cause analysis customer needs assessment database administration coding data agile methodology good work ethic microsoft office critical thinking conflict resolution problem resolution flexible schedule maintenance repair organizational skills data management ms sql server installation configuration performance tuning clientserver connectivity query optimization backuprecovery running database consistency checks using dbcc troubleshooting large databases regularly monitor performance uat prod server cpu memory io using sql profiler spotlight performance monitor dynamic management views wait stats events installation service packs patches ms sql servers 2012 2014201620172019 partitioned tables frequent inserts deletes updates reduce contention improve performance creating login ids passwords roles production nonproduction environment monitor status transactional replication status using replication monitor creating stored procedures triggers views functions performing ms sql database modeling auditing stored procedures optimization improving performance backing system user databases full backup differential backup transaction log backup restoring necessary created ssispackagesfor datamigration scheduledatabasemaintenance job create databases dev qa uat production environment perform database health checks using sql profiler performance monitor performance counters dbcc commands monitor messages nagios sql server load space create alerts notifications system errors insufficient resources fatal database errors hardware errors security breach technical guidance task assignment tracking active 247 technical support monitoring call environments mssql server enterprise 2012 2014 2016 2017 2019 ssis ssrs ssas management studio enterprise manager windows live meeting citrix nagios microsoft excel 2010 tsql performance monitor sqlprofiles microsoft dash board replication monitor mirroring monitor microsoft visual studio microsoft visio quickbase microsoft outlook 2010 dbcc dmv data collector sql database administrator 082019 052021 computer aid trenton nj installing configuring new sql server 2012 20142016 database server instances patching applications migration databases newer releases dropping adding users logins aliases groups databases grantingrevoking permissions database objects sql server integration services ssis sql server reporting services ssrs development testing production environment preparing backup strategy performing full differential transaction log backups restoring whenever necessary regular monitoring sql server performance tuning dropping rebuilding index performance tuning production qa development servers troubleshooting sql server problems related sql server service concurrency blocks deadlocks activity monitor sql agent job execution data transfers various systems using bcp ssis installing sql server service packs database log backups restoration backup strategies scheduling backups backing master system databases restoring necessary configuring developing publishing reporting services using microsoft power bi ssrs resolving various performance issues running dbcc commands sql tracer sql profiler regularly maintained database database consistency check using dbcc schedule jobs database maintenance implemented sql server high availability tools like log shipping mirroring replication always availability group failover created alerts notifications system errors insufficient resources fatal database errors hardware errors security breaches etc provide 247 24x7 production support monitoring call environments mssql server enterprise 2012 2014 2016 ssis ssrs ssas management studio enterprise manager nagios microsoft excel 2007 performance monitor sql profiles microsoft dash board replication monitor mirroring monitor microsoft visual studio quick base microsoft outlook 20032007 dbcc dmv data collector sql server dba 102017 072019 qsronlinecom llc corpus christi tx sql server installation patch application migration databases sql server 2012 201420162017 working various clients multiple product lifecycle environments development missioncritical production systems creating managing schema objects tables views clusters indexes procedures triggers performance monitoring tuning sql servers migration data across different databases different servers install configure informix dynamic server clients performing creation ssis packages extract transform load etl data various data sources like oracle ms access ms excel text files setting transactional snapshot replication among sql server ms sql servers 201420162017 using performance monitor monitoring memory processor disk io user connections finetuning managing security tasks like granting revoking permissions creating alerts notifications system errors troubleshooting problem solving sql servers written stored procedures triggers views functions database log backups restoration backup strategies scheduling backups backing master system databases restoring necessary maintaining database database consistency check using dbcc provide 247 technical support monitoring call environments ms sql server enterprise 2012 2014 2016 2017 windows 20082010 ssrs ssisms sql management studio performance monitor informix dynamic server spotlight performance monitor sql server dba 082016 092017 qsronlinecom llc corpus christi tx jr ms installation configuration ms sql server 2012 2014 create new databases maintenance existing user databases system databases interacting business analysts developers identifying requirements designing implementing database schema performing backup recovery automation backup performance query tuning stored procedures sql queries user defined functions responsible designing implementing backup strategy required running dbcc consistency checks fixing data corruption application databases performing data transfermigration using exportimport ssis managing security tasks like granting revoking permissions monitoring ms sql server performance network issues environments ms sql server enterprise 2012 2014 windows 2008 ssis ms sql management studio education training bachelors degree information technology 082015 addis ababa university