professional summary skills jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom experienced sql server database administrator around 8 years expertise 247365 production environment possess extensive knowledge sql installation configuration optimization server builds patches service packs upgrading troubleshooting sql servers clustered non clustered environments implemented supported different high availability disaster recovery scenarios like alwayson availability groups clustering replication log shipping database mirroring strong dbadevelopment skills writing tsql scripts worked extensively etl process using dts ssis packages handling data quality issues generated various types reports using ssrs olap databases good knowledge experience azure cloud services azure storage azure active directory ad azure vms sql database operating system virtualization window server 20082008r220122012r22016 relational dbms ms sql server migration tools dms dma azure cloud environment development modelling tool data tools 200520082008r220122014201620172019 ms visual studio bids ssms query analyzer access 2000 2005 2008 erwin programming sql tsql cc xml html networking san nas lan wan tcpip ftp smtp performance tool database engine tuning shell scripting power shell advisor profiler performance monitor work history senior sql server database administrator dba wells fargo bellingham wa responsibility 022022 current responsible working 2008 2012 2014 2016 versions sql involved building new secondary data center servers configuring sql 200820122016 dr strategy performed log shipping replication mirroring implemented high availability techniques setting automaticforced fail production servers involved administering servers creating user logins appropriate roles logins monitoring user accounts creation groups granting privileges users groups configured sql server 2016 always availability groups involved analyzing upgrading sql server 2008 sql server 2016 auditing database logins users transactions database activities resolving orphan users troubleshoot blocking deadlocking issues making appropriate changes transaction isolation levels types locks held avoid keeping transactions open long durations breaking large transactions smaller ones scheduling monitoring sql agent jobs designed developed script refresh selective data production development implementing support business needs deadlines extensively worked data migration physical virtual virtual virtual across various versions sql sever work serversan team diagnose io latency occurring several vms suffering io taking longer 15 seconds configured hadr techniques log shipping always managed workload independently collaborated colleagues complete larger scale tasks distributed team environment worked staff develop implement procedures prevent data loss maximize system availability secior sql server database administrator dba wells fargo brentwood tn responsibility 062019 012022 install configure new microsoft sql server instances including always availability groups failover clustering configured maintained iis 60 create database table index stored procedure triggers create users assign permissions based level database access users would need create schedule modify optimize sql server agent jobs maintenance plans verify scheduled job run successful design database backup restoration strategy monitor backups performed regularly configured maintained transactional snapshot replication merge replication experience windows azure migrating database azure worked coordinated developers writing tuning new stored procedures proactively design document promote security best practice policies standards protocols sql environments using sql server management studio perform etl process importing large volumes data cleaned transformed desired format check statistics related memory locks io database response time wait events top sessions background processes monitoring performance physical configuration way database indexed regularly monitor identify blocking lock issues design procedure continuously run production server notifies dba team blockings long running quirestransaction scripted automate day day maintenance tasks using powershell scripts converted existing tsql batch scripts powershell scripts improving sql server maintenance jobs performance configured temp db considerable memory raid levels better performance created internal secured website linking database includes updated information target sql server information create configuring managing virtual machine wrote maintained technical functional specifications document database intentions requirements sco server database administrator technical resource internationaltri city state responsibility worked migrating sql server sql server 2012 sql server 20142016 022017 052019 design implement appropriate database maintenance database systems index maintenance update statistics backup strategies work application teams tuning queries causes extended blocking deadlock locking developed automated tasks daily weekly monthly database maintenance database backup database integrity verification indexing using controlm agent sql server agent developed complex tsql script stored procedure improve performance preserve referential integrity provide application functionality worked linked server run distributed queries sql server oracle databases periodically apply required service packs cumulative updates database servers configured transparent data encryption tde backuprestore strategies encrypted database worked idera tool setting alerts monitors various sql servers different types issues followed standard practices migrating changes test production environments sco server database administrator zambia national commercial bank city state responsibility 082014 012017 installed sql server 201220082008r2 worked applying service pack upgrade sql2012 sp3 sql 2012 sp4 2 node cluster manage logins users assigned roles auditing credential proxies apply least privilege ensure data security perform daily checkups sql jobs replication hardware diagnostics hard drives backups disk space sql windows error logs part proactive maintenance plan created active directory security group table level permission set maintain replication production server provide high availability monitor using replication monitor installed ssl encrypted certificate windows cluster use sql server force encryption incoming sql server connections database servers created develop tables views indexes functions advanced queries database using query analyzer sql server enterprise manager maintain indexrebuild reorganize index periodically created developed stored procedures handle complex business rules history data audit analysis implement ddl triggers created ddl triggers prevent accidental table restrict access unauthorized user design implement manage database maintenance disaster recovery plans including replication fulldifferentialtransactional log backups recovery created mail profile setting alerts using sql mail send automatic mail respective people job failed succeed proactively trouble shoot performance issues sql server error log windows event logs profiler execution plan perfmon activity monitor dmvs documented changes made servers including documentation performance issues designed etl packages dealing different data sources sql server flat files xml loaded data target data sources performing different kind transformation using ssis 20082005 generated periodic reports based statistical analysis data using sql server reporting services ssrs according client requirement education bachelor science information technology certification microsoft certified solutions associate mcsa sql server 20122014 professional developments training microsoft sql server 2012201420162019