jessica claire 100 montgomery st 10th floor 555 4321000 resumesampleexamplecom professional summary seasoned database administrator 10 years extensive experience designing coding testing database solutions zos windows linux environments proficient working diverse technologies db2 zos db2 linux mysql apache cassandra mongodb postgresql exposure amazon rds aurora dynamodb dax redshift document db neptune qldb elasticache timeseries athena database technologies exposure aws services iam ec2 ec2 instance storageebs efs ec2 instance store elastic load balancing auto scaling route 53 s3 cloud front global accelerator sqs sns kinesis ecs fargate lambda function api gateway cloudwatch cloudtrail aws config kms encryption ssm parameter store shield waf vpc configuration internet gateway nat instance vpc peering vpc end points database migration services experienced performance monitoring database object modeling maintenance backup recovery dr maintenance analyzing performance report providing solution experienced informatica power exchange extract transform load etl data across different databases multiple platforms motivated stay informed latest industry innovations provide users uptodate solutions goaloriented team player succeeds working various colleagues clients maintaining communication succeeds highpressure environments meeting business needs project expectations db2 zos db2 luw mysql aurora rds postgresql apache cassandra mongodb dynamodb athena redshift elasticache cics ims skills unix linux windows shell perl jcl rexxcobol java python vsam aws services iam ec2 ebs efs instance store elastic load balancing auto scaling route 53 s3 cloud front global accelerator sqs sns kinesis ecs fargate lambda api gateway cloudwatch cloud trail kms waf shield vps dms work history senior database administrator 102014 current mantech international corporation san diego ca responsible db2 database ddl design implementation maintenance responsible sql system performance io cpu dasd delay tuning resolution database security implemented automated backup strategy script monitor notify cost consuming sql weekly automated maintenance schedule db2 utilities implemented automated database refresh production non production system implemented db2 version migration upgrade exploring features new version set user access objects based racf standards implemented rexx scripts simplify manual task save execution time implemented cross system cdc change data capture db2 zos oracle support 247 data replication implemented informatica power exchange workflow extract transform load etl data across different database multiple platforms provided 24 7 support cassandra poc installed configured tested datastax apache cassandra multinode cluster estimated cluster sizing configured cassandrayaml file modify update configuration improve performance configured cql perform crud operations read write consistency level quorum model created cassandra keyspaces replication compaction strategy nodesync created column families implemented partitioning clustering using primary key implemented vnode configuration performed cassandrastress test monitored performed database operations cassandra using top dstat nodetool commands system output log jvm garbage collection log opscenter life cycle manager gui tool performed node additionremovalreplace node bootstrapping node repair sstablesplit cql copy sstabledump sstableloader dsbulk backup mongodb poc installed configured multinode mongodb cluster configured mongodb configuration file modify cluster configuration improve performance implemented replicas performed additionremoval nodes executed mongodb query language create database collection indexes collations readwrite document readwrite concern crud operations implemented sharding effective sharding keys performed operations configdb get know cluster configuration logs executed mongostat mongotop mongoreplay mongo profiler compass mtools monitor performance cluster schema query resolve senior database administrator 042012 102014 mantech international corporation suitland md maintained multiple qa dev prod db2 subsystems zos designed created objects including database tables stored procedure triggers user defined functions aliases mqt temporal tables referential integrity constraints programs plans automated data migration replication unused storage reclaim backupsnapshot recovery analyzed performance reports proactively identify long running sql queries optimize redesign sql query executed stand alone online utilities perform load unload export import mysqldump reorganize data backup restore repair bulkcopy explain bind clientserver connectivity database consistency check mysql performed mysql server installation maintenance upgrades qa test production linux windows environment handled security schema changes buffer tuning data integrity experienced coding rexx db2 shell perl scripting general system administration skills unix linux zos windows environments effectively used mysql config changes multiple instances hardware upgrades tuned innodb buffer log buffer improve db performance replicated data dataware house environments established high availability replication environment mastermaster masterslave setup environment ability carry security tasks network level blockunblock tcpip ports firewall linux windows blockunblock remote access mysql server performed cpu io memory test using sysbench utilized mysqlslap benchmark tool capture mysqlid performance db2 database engineer zos linux 062008 082009 tata consultancy services ltd city state installedmaintained performed upgrades db2 zos db2 luw ims databases engines created implemented database logical physical database object design including tables indexes functions stored procedures mqt views aliases triggers temporal tables data models database backup recovery strategies created automated script using rexx shell reduce man hours implement regular tasks performed capacity planning resource management sql tuningproactive monitoring report analysis notification executed online stand alone utilities perform export import load unload reorganize data repair tables backupsnapshot recovery updatecollect statistics bind programs plans scripted perform auto data migration production test regions set controlled user profiles access levels database segment protect important data resolved sql error codes locking conflicts performed disastrous recovery set sql replication qreplication blu acceleration hadr set bachelor technology informational technology 062008 psg college technology coimbatore db2 v8 zos certification education certifications mongodb 42 certified dba associate level license 602850608 cassandra administrator certification associate level aws certified cloud partitioner validation number 0eq2n1ml2eveqs9d aws certified solutions architect associate validation number mthhnehlge1qq9cr